Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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,
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement