>>>>Thank you. I will have to figure out a different approach. I will try PACK.
>>>>
>>>>UPDATE: Pack does not work either.
>>>>
>>>>>No. ZAP cannot be used against a buffered cursor/table.
>>>>>
>>>>>>Do you know (of course, I will test it today) if ZAP can be issued against a Cursor Adapter cursor? Because I am trying to avoid opening the table with USE command but rather do everything via CA cursor.
>>>>>>
>>>>>>>After DELETE you'll have table with 10,000 deleted records which can make even SEEK() slow. On other hand ZAP requires exclusive access to the table. I would go with later, if possible.
>>>>>>>>
>>>>>>>>I am opening and updating tables using Cursor Adapter. In one of the procedures I need to zap all records in a table. I can fill the CA cursor with all records, delete records, and then call tableupdate(). But my questions is, how practical this approach if the table can have up to (max) 10,000 records. This is a VFP database (not SQL Server).
>>>
>>>You do not know that you have to have exclusive access to a table to ZAP or PACK it?
>>
>>Yes.
>
>Your questions proved you did not know that before.
Read the question again. It is in English <g>.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
