Release 10.1A: OpenEdge Development:
ProDataSets

> ## 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 Progress 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.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095