HomeActive Query BuilderMemo to display sub-query / derived table SQL only?

Memo to display sub-query / derived table SQL only?


I've followed the Quick start guide to get the basic query example up and running :-)

Is it possible for the memo to update and only display the content of the currently selected sub-query, and any of it's "children"? At the moment the memo displays the entire query regardless of which tab is selected.
IanH | email
March 24 2008, 05:49 AM
Dear Ian,

Use the following event handler for the TacQueryBuilder.ActiveSubQueryChanged event to get text of the currently active sub-query.

procedure TForm1.acQueryBuilder1ActiveSubQueryChanged(Sender: TObject);
begin
eSQLCurrent.Text:=acQueryBuilder1.ActiveSubQuery.GetResultSQL(acSQLBuilderPlainText1.SQLBuilder);
end;

Sergey
Sergey Smagin | email
3 days, 22 hours since original post
This topic is closed