<rant>
Then the simple solution is to create a one column table with a datatype of
number, lock the whole table and update it for each transaction. This is
entirely database independent and doesn't even require changing the
definition of the database across platforms.
</rant>
Your solution is already not database independent because you don't have
triggers in access or autonumber in oracle. use the power of the platform.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Sheridan" <gh_at_hakom.at> wrote in message
news:EzV_8.3$Eh.163_at_stuart.coltnet.at...
> Sorry, I have forgotton to explaine that I do not won't to use oracle
> specific things like SET TRANSACTION LEVEL SERIALIZABLE
> because our libraries should be independent from the used database.
>
> Therefore I want to use "SELECT Max(ID) FROM Table" in combination with
the
> isolation level to get the ID
> because Access uses AutoValue to genarte an unique key
> and Oracle use a trigger for that.
>
>
>
>
Received on Mon Jul 22 2002 - 15:07:26 CDT
