Is the view parameterized? Assume the name of the parameter is pID:
pID = -1
requery("myView")
>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,
Steve Gibson