i have this in my main form's load event..
>
>set exclusive off
>set multilocks on
>
>use fbc again shared in 0
>=cursorsetprop("buffering", 1, "fbc")
>sele fbc
>zap
>=cursorsetprop("buffering", 5, "fbc")
>
>
>error shows that file must be open exclusively.. what is wrong?You opened your file SHARED. ZAP requires the file to be opened EXCLUSIVE.
If fbc is really a shared file (meaning shared by the users of the app in the LAN), then you cannot do this as every user would be attmpting to ZAP when starting their program.
What you probably want to do is to copy the fbc structure either with
COPY STRUCTURE
or with
SELECT * FROM fbc WHERE 0=1 INTO CURSOR crsFBC READWRITE
. Then you would have a local cursor (or table) in the local PC that you could ZAP and use to your liking, then post back to the server when done. This way you could have your local PC working files (temp files) used always EXCLUSIVE.
HTH