General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Steve
Wires crossed here I think:)
We are talking about a UT Article called
The Easy Way to Form a Primary Key
Not Craig's proggy :)
>Mark,
>
>Are you saying the "usual" method of locking the record is not possible in a multi-user environment? The lock would be *very* brief, only when a record is added. If the user decides to edit the new record, there shouldn't be a problem.
>
>However, the method on Craig Berntson's website briefly locks the entire key table, and from what I understand that code has proven to be reliable in heavy multi-user systems.
>
>>
>>I was a bit suspicious about that myself. The usual keytable methods lock the record in the keytable briefly to guarantee a unique key is returned.
>>
>>That would not be possible in a muti user environment because a user might be editing the latest record.
>>
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only