ROWID with instead of views?

[Christen]

I have created dataset for an updatable view with instead of triggers. The 'UniqueFields' property of the dataset was settled to the correct fields but the dataset was not updatable until I added a dummy (NULL as "ROWID") field to que SQL sentence.
Why it is not enough to set the 'UniqueFields' property to make updatable the dataset?.

I would aprreciate your comments.

 

[Marco Kalter]

The TOracleDataSet still uses the rowid to identify a record. Howeverm when inserting a new record into a view with an instead of trigger, Oracle does not return a rowid. Therefore the primary or unique key columns are required to find the rowid.

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

 

[Christen]

If so, why does not use the unique fields (and therefore requiring a ROWID field) in update or delete operations?

Thanks

 

[Marco Kalter]

Because rowid's identify records in the TOracleDataSet.

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