>I wanan update the content of a table in my program, before saving of course I have to check if any other is using the table, so i tried to use the example from MSDN about IsExclusive..
>
>my program:
>1: set exclusive off
>2: open
in 0 exclusive
>3: if IsExclusive() then
>4: **do the updates here**
>5: else
>6: **prompt error message**
>7: endif
>
>To test the program, I open the database exclusively in another program, and then run the above code. A "access denied" message pops up at line 2.
>
>So what should I do, if I wanna ensure there's no one using the table, and then update it?
>
>Thanks for any help in advance!
addon error *
and the error will be bypassed and your can see if it got used exclusively.
Inside the 'if isexclusive() branch' change the on error statement to something more useful like a procedure to trap other program errors. See ON ERROR in the help file
hth
Alek
Alek Massey
- The only stupid question is one left unasked -