Some think like this may be an approach

procedure TFMain.BTFirebirdMonitorClick(Sender: TObject);
begin
IB_MonitorDialog.ShowOnlyOne;
end;

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of mnrroux
Sent: Friday, June 22, 2012 12:33 AM
To: ibobjects@yahoogroups.com
Subject: [IBO] How to get final SQL text executed when using ParamByName to
set parameters

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.



------------------------------------

___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
Yahoo! Groups Links