How to empty ZTable

stiff · Post by **stiff** » 18.07.2009, 13:39

The ZTable doesn't have an EmptyTable method like the bde. How is this achieved? EmptyDataSet doesn't work.

Post by **seawolf** » 18.07.2009, 21:03

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

stiff · Post by **stiff** » 18.07.2009, 21:39

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.

stiff · Post by **stiff** » 19.07.2009, 02:43

The way to empty the table is with the SQL DELETE from ddl.