Hello,

The primary key is generated from a different table.

I have made a function to get the next key, this key i use in my insert statement. these two steps are two transaction.

Know i want to make it in a different way, if the key is not filled in in the insert statement, then the before trigger fills it , with the same function as before.

But know it is one transaction, this is not what i want.
Because al the time is the key table locked.

Does someone know a soultion for this.

It has to work on Oracle,MSSql and Sybase.

Thanks