Page 1 of 1

information of the result of a statement

Posted: Mon 13 Jun 2005 09:03
by cleaverX
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

Posted: Mon 13 Jun 2005 13:09
by Ikar
You can use TMyQuery or TMyServerControl.OptimizeTable with the same success. TMyCommand also can be used but then you cannot get a result.