Walter Meester
HoogkarspelNetherlands
General information
Category:
Coding, syntax & commands
Hi Jill,
In that case you might try to use RLOCK(0) which locks only the table header. This will refresh the local buffer, allows other records to be locked, and prevent other users to INSERT records while you hold the table header lock.
Walter,
>Walter,
>
>>You can eliminate the issue by placing a file lock on the table before you seek(),
>
>uh-uh...can't do that...since I'm using this as a semaphore file...and keeping the record for a reservation locked...it may be locked for awhile...that would prevent other users from locking any other reservations.
>
>
>Will have to try the SET REFRESH setting.
>
>Thanks...J
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