information of the result of a statement

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
cleaverX

information of the result of a statement

Post by cleaverX » Mon 13 Jun 2005 09:03

hi,

i want to execute a statement like 'optimize table tbllogs' and then access the information that is returned from that statement:

+---------------------+----------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+---------------------+----------+----------+----------+
| database.tbllog | optimize | status | OK |
+---------------------+----------+----------+----------+

Where can i access this information?
What component is best for this: TMyCommand, TMyServerControl, ...?
Thanks

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Mon 13 Jun 2005 13:09

You can use TMyQuery or TMyServerControl.OptimizeTable with the same success. TMyCommand also can be used but then you cannot get a result.

Post Reply