Devart Forums

I want my user to be able to change data in a grid that is linked to a READ ONLY ODAC TOraQuery.

I want to allow the user to change data in the grid.
I would like to intercept the change events and run my own code
instead of the change being sent to the database

Is it possible to do this ?

What events and properties do I need to use on the grid or query ?

I need the solution to be entirely within Delphi as I cant make changes to the database such as using view triggers

Environment : D2009 and ODAC

Please help. Thanks

ODAC does not have such feature. You can only assing custom SQL statements to the SQLInsert, SQLUpdate, and SQLDelete properties (for example, stored procedure calls).