Sequential Keys - Unique? (None Specified)
At 01 SEP 1999 05:25:05PM Paxton Scott wrote:
Before we create the logic, want to be sure I have not missed something. Does OI handle providing multiple data entry persons with unique keys?…We don't mind a few 'holes' due to a key being handed and not used….We have discovered the same limitation as AREV, same key handed to two stations, "last one to save wins". No warning even.
arcs@arcscustomsoftware.com
[url=http://www.arcscustomsoftware/]ARCS, Inc.
At 02 SEP 1999 03:32AM Oystein Reigem wrote:
Paxton,
If you lock the key two users will not get the same key. But if a user changes her mind you may get 'holes'.
You might want to read the thread
http://www.revelation.com/WEBSITE/DISCUSS.NSF/f12696d31000b22a8525652b00831bb2/12b26e71dd845745852565380041b097?OpenDocument where I asked the same question as you.
Mark Martin, Revelation, published a function theat finds the next available key. See http://www.revelation.com/WEBSITE/DISCUSS.NSF/f12696d31000b22a8525652b00831bb2/26b5e3cd1bb74613852563a9006b8b79?OpenDocument. The function locks the key.
See also http://www.revelation.com/THEWORKS/OIdiscuss.nsf/ef8405490de3608f85256700005245e4/ee3a291acf4252fb852567550034df9c?OpenDocument for my own version of that function.
- Oystein -