Report dataset SQL
How do I get the SQL text from a TfrxADOQuery in my FastReport? I want to access the SQL so I can alter it at run time.
I want it to work like this:
tQryText := frxReport1.Dataset.Sql;
frxReport1.Dataset.Sql := tqyrText + 'order by name';
Any input would be appreciated! Thank you!
I want it to work like this:
tQryText := frxReport1.Dataset.Sql;
frxReport1.Dataset.Sql := tqyrText + 'order by name';
Any input would be appreciated! Thank you!
Comments
typically write code to load report and then use the find object method to locate the query,
cast it to its type and set its properties before calling show or prepare.