Update grid data for a non updatable query

DuckyDuck · Post by **DuckyDuck** » Mon 26 Oct 2009 13:30

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

Plash · Post by **Plash** » Tue 27 Oct 2009 10:59

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).