Page 1 of 1

Before Execute SQL We can know the sql text in TMyConnection?

Posted: Thu 10 May 2007 06:02
by chintatlim
hi,
If i want to know sql text before execute/open, where can know it?

TMyConnection support before runsql event?

thank you.

Posted: Thu 10 May 2007 07:29
by Antaeus
You can set the Debug property to True for the component you want to trace, and add the MyDACVCL unit to the uses clause. In this case SQL statements will be shown in the Debug window before sending to the server.
Another way is to place the TMySQLMonitor component onto your form and add a handler for the OnSQL event.