>>It works the same way on SQL Server with the syntax difference (HOLDLOCK)
>>*** Stored Procedure
>>Begin tran
>>Select @my_id=id from TSetup HOLDLOCK where code=55
>>Update TSetup Set id=@my_id+1 where code=55
>>Commit tran
>
>Oh, but I don't have SQL-Server on the server ! (sigh)
>Users will have access to the remote tables using remote views...

but what back-end you use? Oracle?