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

chintatlim · Post by **chintatlim** » Thu 10 May 2007 06:02

hi,
If i want to know sql text before execute/open, where can know it?

TMyConnection support before runsql event?

thank you.

Antaeus · Post by **Antaeus** » Thu 10 May 2007 07:29

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.