>>>>>Hi,
>>>>>
>>>>>I am trying to ZAP records in the cursor which has the Buffering set to 5 (I tested using CursorGetProp())
>>>>>
>>>>>So I need to first change the Buffering to 1, right? Here is how I do it:
>>>>>
>>>>>
>>>>>lSuccess = CURSORSETPROP("Buffering", 1, cViewName)
>>>>>
>>>>>
>>>>>But I get a message that "The view require either db_bufoptrow or db_bufoptable" . What do I need to do?
>>>>>
>>>>>TIA
>>>>>
>>>>>UPDATE. This cursor was created as a cursor to Cursor Adapter object. But then it was detached. I suppose VFP still "considers" it as a view. So I need to learn how to change this cursor from a "view" to an ordinary cursor; so that I can ZAP it.
>>>>
>>>>
>>>>Hi,
>>>>
>>>>In my opinion to zap a cursor is useless, just recreate the cursor from the start, vfp will overwrite the old cursor with the newly created one.
>>>
>>>When the cursor is the RecordSource for a grid, zapping and refilling is the way to go.
>>>
>>>Tamar
>>Tamar,
>>of course, you are correct, this is what Andy used to call a safeselect().
>>Regards,
>>Koen
>
>I used ZAP to let the user empty a cursor bound to a grid instead of re-running the query with a where 1=0 condition. That can be much faster depending on the query and the network and remote database.
Mike,
Your reply puzzles me. What is different to Andy's SafeSelect with your doing here described?
Regards,
Koen