Board index » delphi » How to Empty MS Access Tables

How to Empty MS Access Tables

Try using the TTable.EmptyTable method....

Woody

Quote
Anthony Magauran wrote in message <6vdte2$k...@forums.borland.com>...
>I want to empty MS Access tables before appending a blank form.

>I find that using a query component causes gives error messages
unless I
>deactivate the datasets used by the form before executing the query
and
>reactivating them afterwards.

>This makes for very slow responses.

>Any other way of doing this would be appreaciated.

>PS it took me ages to discover what was causing the error messages as
the
>program logic seemed correct.

 

Re:How to Empty MS Access Tables


You could use a NEW tquery

"delete from table1"

It will be not be connected to your datasets. Then you will have to close
and reopen
your other query.

Quote
Anthony Magauran wrote in message <6vdte2$k...@forums.borland.com>...
>I want to empty MS Access tables before appending a blank form.

>I find that using a query component causes gives error messages unless I
>deactivate the datasets used by the form before executing the query and
>reactivating them afterwards.

>This makes for very slow responses.

>Any other way of doing this would be appreaciated.

>PS it took me ages to discover what was causing the error messages as the
>program logic seemed correct.

Other Threads