Hello Marco!
I think, It's nessesary to introduce new property (UpdateKind ?) in the TOracleDataset, which determinate what kind of updates to use: ROWID or UniqueFields. There are no any difficulties to implement "UniqueFields" updates. I'm glad to help you...
Hello Marco!
I think, It's nessesary to introduce new property in the TOracleDataset, which determinate what kind of updates used: ROWID
or UniqueFields (UpdateKind ?). There are no any difficulties to implement "UniqueFields" updates. I'm glad to help you...
I copy this topic from the DOA Beta forum.
posted 12 September 2003 16:31
--------------------------------------------------------------------------------
Hello Marco!
Are You planning release the CachedUpdates based on TOracleDataSet.UniqueFields? The ROWID is not suitable for any needs, e.g...
Hi!
If view has DISTINCT, GROUP BY, UNION clause and join several tables all update logic release in instead of trigger, so ROWID cached updates works only with one updating table. I must specify UpdatingTable for CashedUpdates and DOA produce this statements:
DOA DMLQuery
1) select * from...
Hello Marco!
Are You planning release the CachedUpdates based on TOracleDataSet.UniqueFields? The ROWID is not suitable for any needs, e.g. updates Views with instead of triggers.
Andrew.