Try OpenEdge Now
skip to main content
ProDataSets
Dynamic ProDataSet Basics : Deleting a dynamic ProDataSet
 

Deleting a dynamic ProDataSet

When you are finished using a dynamic ProDataSet, you must delete it explicitly with the same statement you use for other ABL dynamic objects, as shown in the following syntax:

Syntax

DELETE OBJECT dataset-handle [NO-ERROR].
You can also delete the ProDataSet by deleting its named widget pool if it was created in one. If the ProDataSet is being passed as an output parameter, its widget pool should not be deleted in the called procedure. It is okay to delete the ProDataSet object itself in the called procedure. If the ProDataSet is in the unnamed session widget pool, the deletion will be delayed in the same way that TEMP-TABLE object deletions are delayed when they are output parameters. If the ProDataSet is in a named widget pool, it will be deleted when the widget pool is deleted.
Dynamic buffers and tables in a dynamic ProDataSet are normally deleted automatically when the ProDataSet is deleted. If you do not want one of a dynamic ProDataSet's buffers or temp-tables to be deleted, you can set the LOGICAL buffer attribute AUTO-DELETE to false to prevent auto-deletion of the buffer and its temp-table. This applies only to dynamic buffers.