Subject | Re: [IBO] EmptyTable |
---|---|
Author | Svein Erling Tysvær |
Post date | 2001-03-06T12:13:01Z |
The dataset compatible TIBOTable should have EmptyTable available. For the
native components, use an TIB_DSQL with SQL like DELETE FROM <table>
without a where clause. The delete itself won't take long, but garbage
collection the next time you e.g. issue a SELECT may be expensive depending
on your indexes and size of the table before the delete.
Set
At 07:53 06.03.2001 -0000, you wrote:
native components, use an TIB_DSQL with SQL like DELETE FROM <table>
without a where clause. The delete itself won't take long, but garbage
collection the next time you e.g. issue a SELECT may be expensive depending
on your indexes and size of the table before the delete.
Set
At 07:53 06.03.2001 -0000, you wrote:
>I would like to know what the IBO equivalent of the BDE EmptyTable
>is. I need to delete all the records from a table before my program
>starts it's processing.