Page 1 of 1

How to empty ZTable

Posted: 18.07.2009, 13:39
by stiff
The ZTable doesn't have an EmptyTable method like the bde. How is this achieved? EmptyDataSet doesn't work.

Posted: 18.07.2009, 21:03
by seawolf
Before empty a table you have to verify if there are foreign keys or views.
EmptyDataset works fine but only on data cached and the results are not send to the db

How to empty ZTable

Posted: 18.07.2009, 21:39
by stiff
I am not familiar with cached data and where it is. I am running the embedded version of fb and have created a temp table that will hold entered data because the operation pops in and out of other Forms. When finished and in Formdestroy, the table should be emptied for the next usage.

How can the Emptydataset be coded if the data isn't needed anymore? It is saved to other tables before this op.

How to empty ZTable

Posted: 19.07.2009, 02:43
by stiff
The way to empty the table is with the SQL DELETE from ddl.