instead of triggers

[anitha]

I have DOA 3.4.5 on Delphi 5 and I want to use an updateable dataset for a view with an 'instead of' triggers.
I already have rowid in my 'create view ' statement .
I wanted to use 'Instead of ' Triggers as I wanted to 'order by' in my 'create view' stmt.
Do I need to set anything more ,either in PL/SQL Developer or DOA (as I use both of them , individually) ?
Any help is appreciated.

(p.s. I can update the view from SQL PLUS)
Thanks

 

[Marco Kalter]

It seems that you cannot execute a "select ... for update" against a view with an order by clause. Direct Oracle Access executes this to lock a record. You have to move the order by clause from the view to the application's SQL statement.

Furthermore, the UniqueFields of the dataset must be set to the field names that uniquely identify a record.

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