I am trying to change SQL in TOracleDataSet in runtime and it does not work with QBE. For example I have SQL
Select * from all_tables I do QBE and TOracleDataSet changes SQL to
select * from all_tables
where (OWNER = 'SYS')
/* Modified for QBE */
Now in code I add new line,something like
q->SQL->Add( "Order by 3");
q->Refresh();
SQL:
select * from all_tables
where (OWNER = 'SYS')
/* Modified for QBE */
Order by 3If now I do QBE searching for owner=