>I just tested this and I don't understand the results:
>
>SET DATASESSION TO 2
>wait windows iif(flock("trtradm"), "lock OK", "lock not ok")
>
>**Message displayed: Lock OK
>
>SET DATASESSION TO 1
>wait windows iif(flock("trtradm"), "lock OK", "lock not ok")
>
>**Message Displayed: Lock not OK, very fast
>
>SET DATASESSION TO 1
>set reprocess to 100 seconds
>wait windows iif(flock("trtradm"), "lock OK", "lock not ok")
>
>** Message Displayed: Lock not OK, very fast it did not tried for 100 seconds for sure.
>
>
>There must be something I don't do correctly but what?
You probably don't have the table open in the main datasession (1) at all. You can't do a FLOCK() if it's not open.