>Hi Peter
>
>Is the rlock or flock is a good option to find out if someone else is trying to use a file exclusive on another network computer ??? Your input will be appreciated.
Use ISRLOCKED() or ISFLOCKED() to find out whether someone else (not this same user in this same session) has already placed a lock. USE [file] EXCLUSIVE indeed locks the whole table.
You can also use RLOCK() and FLOCK() to find out the status. A simple RLOCK() / FLOCK() returns False if the table is locked by someone else.
Groet,
Peter de Valença
Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.