>>>I want to ZAP a table on a network. my code is:
>>>use mytable excl
>>>zap
>>>
>>>there is no one else is using the app. my table does not get zap.
>>>is there a return code for USE MYTABLE EXCL? why are my records still there?
>>
>>We have had problems with this too... try..
>>
>>use mytable excl
>>go top
>>zap
>>flush
>>use
>>
>>Or try go recno() instead of go top if that doesn't work.
>>
>>BOb
>thanks - that did not work either. I think I will try DELETE ALL.
Robert,
Might this be :
You're opening your table again with exclusive clause in another workarea and "excl" ignored w/o a message. If so you better :
if used("mytable.dbf")
use in "mytable.dbf"
endif
use mytable.dbf excl
zap
But of course if it's something you zap frequently (w/o saving to next session) you might prefer a cursor.
Cetin