>buffering does locking as well'
>if you are wondering regarding the scatter/gather way of doing thing -
>then bufferring is much better solution
>
>Arnon
>
>>
>> The docs seem to be mute on this issue, so the answers you get should
>prove
>> to be interesting indeed.
>>
>> Cheers,
>> Jim N.
>>
>> >Are there still advantages to record/file locking or is buffering
>> >sufficient?
>> >
>> >My primary concern regards system counter fields that are being stepped
>> >by mutiple users, probably at the same time (trans. id, etc).
>> >
>> >Will buffering do it? Will a loop using TABLEUPDATE() work?
>
>ID generating is not a place to use buffering becasue you want ot update
>the system
>ASAP
>I use a table which holds the ID and transcations (BEGIN TRANSACTION etc.
>)to lock the table (just like VFPs RI builder)
>
>Arnon
>
>Arnon
Thank you sir. That's exactly what I needed!
Matt
Matt McDonnell
...building a better mousetrap with moldy cheese...