You should find the Oracle command equivalent for ZAP and use that via SPT.

ZAPing a view would empty the set of records that exist on the local machine. You might try a tableupdate() after the zap.

The only use I have for ZAP in a production app is to clear out the local set of records which a user might want to do between searches.

>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,