CachedUpdates without ROWID

[nicofari]

Hello,

I have DOA 4.0.4
I would need to use a TOracleDataset in cached updates on a view with instead of triggers (so I have no rowid).

I found an old message (2003) in this forum asking about this topic and proposing using the UniqueFields property instead of the rowid.

I tried with 4.0.4 but it seems not yet implemented.

Does this feature exist in next releases ?

Thanks in advance
Bye
Nicola

 

[Marco Kalter]

A view with instead of triggers can still return a rowid. If you include it, you can use cached updates if the UniqueFields property is defined correctly.

 

[nicofari]

You are right, my words were not accurate nor precise.
The true reason is that this view contains a union, so it is not key-preserved nor can contain a rowid, hence my question.
If this feature would be implemented we can save some effort.
But I guess from your answer that you probably didn't implemented it, right?

Bye
Nicola

 

[Marco Kalter]

That's right, you still need a rowid, so in this case you cannot update the view through a dataset.

 

[nicofari]

Marco,

Execuse me, but it seems that I am unable to clearly
explain my question because of my poor english.

The rowid can be surrogated for updating purpose by the UniqueFields property, do you agree?
Actually my question was if you think this feature will be (or was already) added to DOA.
This is what I am asking for because the same thing was asked in this topic:
http://www.allroundautomations.com/ubb/ultimatebb.php?ubb=get_topic;f=1;t=001724#000000
and you answered that you will consider this.

So my question is:
Is already implemented this feature (=using uniquefields instead of rowid for update in cachedupdates) and if so in which DOA version?

Thanks a lot
Bye
Nicola

 

[Marco Kalter]

No. Like I said, you cannot update the view through a dataset.