USE bookings IN (SELECT("Bookings")) ALIAS muh USE bookings IN (SELECT("Bookings")) EXCLUSIVE *boomeven better
USE bookings IN (SELECT("Bookings")) USE bookings IN (SELECT("Bookings")) AGAIN ALIAS muh USE bookings IN (SELECT("Bookings")) EXCLUSIVE *boomwe do not talk datasessions and concurent use
SELECT SELECT("Bookings") USE bookings EXCLUSIVEwill work with SELECT before USE. Even five char smaller code
>USE bookings IN (SELECT("Bookings")) EXCLUSIVE >SELECT Bookings >>So if the table is already open in another work area, then it will be reopened in the same work area.
>>SET SAFETY OFF >>SET EXCLUSIVE on >>USE bookings IN 0 EXCLUSIVE &&I have tried it with and without the exclusive clause. Makes no difference. >>DELETE ALL >>PACK >>IF ISEXCLUSIVE( ) &&Just to check if there is exclusivity. returns .f. each time - no matter what I change around in the code. >> MESSAGEBOX('Table opened exclusive') >>ELSE >> MESSAGEBOX('Not opened exclusively') >>ENDIF >>SET EXCLUSIVE OFF >>SET SAFETY ON >>