information of the result of a statement

information of the result of a statement

Postby 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
cleaverX
 

Postby 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.
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56


Return to MySQL Data Access Components