{{tag>category:"None Specified" author:"Paxton Scott" author:"Oystein Reigem"}} [[https://www.revelation.com/the-works|Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community]] ==== 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. [img]http://www.arcscustomsoftware.com/arcslogo.gif[/img] ---- === At 02 SEP 1999 03:32AM Oystein Reigem wrote: === Paxton, If you [i]lock[/i] 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 - [[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=WORKS_READ&SUMMARY=1&KEY=7FA9B89FBBE318D2852567DF0075A732|View this thread on the Works forum...]]