Is the view parameterized? Assume the name of the parameter is pID:

pID = -1  && use a value that will retrieve zero records
requery("myView")  && I'm assuming the view is already in USE

>i'm using Intersolve ODBC driver for Oracle.
>i can scan a local free VFP table and insert
>each record into a remote view. prior to that scan
>loop, i need to delete all
>the records from that remote view (Oracle table).
>i issue a ZAP command and even close the view and
>re-open the view, but the records are still there.
>i tried to issue a PACK command, but got message
>that PACK is not a valid command for remote views.
>what should i be doing ?
>
>thanks for your help,