Page 1 of 1

This is the sample source of happening error.(ODAC)

Posted: Mon 20 Mar 2006 06:12
by ckscksoo
I have made the application to use Delphi 7, ODAC 5.50.0.17 vesion, OraQuery -> DataSetProvider -> ClientDataSet -> DataSet -> cxGrid(QuantumGrid DBBandedTableView)

But, when Cache Update(ApplyUpdates), "ORA-00971 missing SET keyword" come out.
I think that error come out when DataSet is Filtered
I want to know why it come out

Click Sample Source Download

Posted: Mon 20 Mar 2006 15:50
by Alex
Please use TSmartQuery component instead of TOraQuery to resolve such problems.
To do this right-click on TOraQuery component and choose "Convert to TSmartQuery" menu item.