Database Experience

[Rick Harrison]

>
> I don't believe MySQL has any built-in record locking functionality- 
> that's the bad news. The good news is that even if it did, it would be 
> about the same amount of work in the simple case.
>
> Suppose you were to write a front-end in Revolution, and had no 
> control over the back-end (other than that it was a MySQL server 
> sitting somewhere).
>
> All you would need to do would be to create extra fields in your MySQL 
> database, something like:
>
> RECORD_LOCKS
> lockedBy: yennieb
> lockTime: 278236472
>
>

Brian,

Thanks for the specific answer.  I'm sure it is helpful to a lot of 
people
out there since this is a topic that usually isn't discussed much.

Thanks again!

Rick Harrison