CachedUpdates and Unique Index?

[Stevie]

Hello,

I've got a TOracleDataSet with CachedUpdates = True

I've changed two records where the first of them is violating the an UniqueIndex of the table which is on the second record although the second record now (that it's changed) has a different index!

The error wouldn't be if the second record would be updated first. Is there a way to work around?

Thx
Stevie

 

[Marco Kalter]

You could define the unique constraint as deferred. This way it is checked at the transaction level.

 

[Stevie]

How can I do this? I only found how I can do this with Constraints, but not with unique indizes!?

Can you please post an example?

My Index is defined as:

CREATE UNIQUE INDEX SU_REGELN_INDIZES ON SU_REGELN_INDIZES
(NACH_INDEX, VON_INDEX, SU_REGELN_ID)

 

[Jens Fudickar]

Create an unique constraint, and not an unique index. The unique index is then created automaticly.

Greetings
Jens

 

[Stevie]

Now it works! Thanks!!