ORA-00971: missing SET keyword

[danielm]

When i try to update some records that return from a TOracleDataSet, on ApplyUpdates give me the message "ORA-00971: missing SET keyword". The provider flags are correctly set. The problem ocurr only when there is a "ORDER BY" on my Query diferent from table PK. Someone can help me? Thanks.

------------------

 

[Marco Kalter]

How have you set TDataSetProvider.ResolveToDataSet? What is the actual update statement that is executed? You can verify this with the Oracle Monitor.

------------------
Marco Kalter
Allround Automations