Hello, All!

Please, I have a problem which is drive me crazy today: how can I assure an unique id number for multiuser table buffering updates? To be more explicit:

I want the users to be able to extract next id from table (this is an easy thing to do) then to append records in a local view from that table (this is also easy to do), then to update the base table, using TABLEUPDATE. Now follows the hard part: when they click on the 'Update' button, the application should extract the next id, then the records from local view are renumbered and updated. But:

Is there a small window of time (between the finding the next id and the update) in wich another user can do the update. And locally the records are numbered with id's already existent in the base table! (inserted by the other user). I know that the time is about miliseconds, but if there are many users, is possible the records from different computers to be numbered with the same numbers. This is no theorethical disscusion. This has happend to me, yesterday. The result - database inconsistencies.

I wonder, is there a way to eliminate this problem? (I'm not considering table locking. I expect something else).

Many thanks.

Grigore Dolghin