General information
Category:
Coding, syntax & commands
>Craig,
>
>One of us is misunderstanding - probably poor explanation on my part!
>
>I'm not looking to a get a new BLANK RECORD - but to essentially lose ALL the existing records in the view. Let's say I requery the view and end up with 5 records in it. After modifying and updating those records, I want to "clear" the view - that is - set it to have no records just like it had just been opened "nodata"
>
>DELETE ALL won't work because that "modifies" the view and goes to back-end - and I don't want to have to requery with some dummy parameter - that seems silly and takes time.
>
>Thanks for your help!
>Ken
>
>>>Hi,
>>>
>>>Does anyone know of a way to "empty" a paramaterized view without having to requery it? Essentially, I would like to put it back to "nodata" status. At the time I want to do this, the view has been updated (currently unmodified) and thus, not sitting with any uncommitted records.
>>>
>>>TIA!
>>>Ken
>>
>>APPEND BLANK into the view. Make sure you REVERT before doing anything else.
Ken,
Could you not do the following
SELECT cView
=TABLEUPDATE(.T., .T.)
USE cView NODATA
Just a thought ?
Mark Letheren
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only