Database Experience

[Bruce Robertson]

> On Mar 23, 2004, at 12:19 AM, Bruce Robertson wrote:
> 
>> And you do? MySQL does? I don't think so.
>> 
>> The internet is stateless. If you want to build a custom record locking
>> solution for web transactions, you can do it and you will face the same
>> issues in any  system. It only takes a very simple calculation in edit
>> privileges to accomplish.
> 
> uh... I use XML and a little array. when record is accessed, the arrays
> (hum... actually is not an array, it's a queue) is checked, if the
> record is in the arrays, this meaning it's being edited right now, then
> it cannot be accessed, if it's not in the array, then it's unlocked.
> This is done before any DB connection function. It works fine. what do
> you think?

There is nothing that prevents you from using that approach with Filemaker
also if you want to; or you could use the easier native record locking
options.  

I don't quite understand how you lock a record without knowing what record
you're locking. You say you can lock a record or determine its lock status
without a DB connection. How does that work? How do you perform a query
without performing a query?