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.