How can I do empty table in the UniTable ?

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Fastex
Posts: 15
Joined: Wed 20 Oct 2010 08:52

How can I do empty table in the UniTable ?

Post by Fastex » Fri 29 Oct 2010 09:13

I want clear table like in component TTable->EmptyTable(). How can I do this ?

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Post by AlexP » Fri 29 Oct 2010 10:52

Hello,

We will investigate the possibility of adding the EmptyTable method in one of the next builds/versions of MyDAC.
For the time being you can use the TUniConnection.ExecSQL function to clear your table.
The Sql syntax depends on your database.
For most databases you can use the following SQL code:
'DELETE FROM YOUR_TABLE_NAME'

Post Reply