| Subject | How to get final SQL text executed when using ParamByName to set parameters |
|---|---|
| Author | mnrroux |
| Post date | 2012-06-22T06:33:24Z |
Hi there,
How can I obtain the final SQL statement executed when setting SQL like below.
Eg.
QDSQL.SQL.Add('Update Records');
QDSQL.SQL.Add('Set FilePath = :FilePath');
...
QDSQL.ParamByName('FilePath').AsString := 'Test';
QDSQL.ExecSQL;
I want to get the follow SQL:
Update Records Set FilePath = 'Test'
How can I obtain the final SQL executed? Thanks in advance for the assistance.
How can I obtain the final SQL statement executed when setting SQL like below.
Eg.
QDSQL.SQL.Add('Update Records');
QDSQL.SQL.Add('Set FilePath = :FilePath');
...
QDSQL.ParamByName('FilePath').AsString := 'Test';
QDSQL.ExecSQL;
I want to get the follow SQL:
Update Records Set FilePath = 'Test'
How can I obtain the final SQL executed? Thanks in advance for the assistance.