Page 1 of 1

How to Reload dml uniquery.

Posted: Mon 14 May 2018 17:23
by sounobre
Good afternoon!
After I use uniquery.sql.clear, would I have some way to give it a reload in the original uniquery?

Example:

Delphi
uniqueryTest object is equal to "select * from table1"

uniqueryTest.close;
uniqueryTest.clear;
uniqueryTest.sql.text: = 'select * from table2';

Is there any command I use that returns the uniqueryTest object to its original state, "select * from table1"?

Thank you.

Re: How to Reload dml uniquery.

Posted: Tue 15 May 2018 09:48
by azyk
The TUniQuery component does not store the history of the executed SQL queries. You can store this history yourself using the onSQL event handler of the TUniSQLMonitor component. For example:

Code: Select all

procedure TForm1.UniSQLMonitor1SQL(Sender: TObject; Text: string;
  Flag: TDATraceFlag);
begin
  ...
  Memo1.Lines.Add(Text);
  ...
end;
More information about TUniSQLMonitor in our online documentation:
https://www.devart.com/unidac/docs/deva ... onitor.htm