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

ckscksoo · Post by **ckscksoo** » Mon 20 Mar 2006 06:12

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

Alex · Post by **Alex** » Mon 20 Mar 2006 15:50

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.