Ken,
I think your only options are to open it again with USE ... NODATA or requery it with a parameter you know won't return any records.
>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