>>>>I used both zap, and delete all, pack, and neither works. I just need to empty the file so it it can be filled with fresh, relevant data. I have resorted to using SQL select and a cursor, which I make the grid's record source, so now I don't need to empty the table anymore. I am sorry, and no offense, but zap, and delete all/pack are the only two ways I know of emptying a table..
>>>
>>>John,
>>>zap, delete and pack all work No question. The reason that the result you are looking at is not what one would expect, to my best bet is, is to be found in your coding or environment.
>>>what do you see in your debugger when you check for reccount()?
>>>Regards,
>>>Koen
>>
>>Unless I'm mistaken here - he doesn't have exclusive use of the table ... so all of this is moot until that is resolved.
>
>Victor,
>I bet on
, or even worse there are more than one table in his environment with the same name.
>Rgds,
>Koen
Even if this returns OFF...
?SET("Exclusive")
This will still open the table exclusively ..
USE Bookings EXCLUSIVE IN 0
...unless something else has the file open. Either another user has it open, or something on the server which has the table has a hold of it. If nothing else has a hold of the table (which I doubt) - then there is a permissions problem with the folder that holds the table or the table files themselves.
ICQ 10556 (ya), 254117