Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Copy To
Message
De
06/11/2013 06:21:05
 
 
À
06/11/2013 06:12:26
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Web
Divers
Thread ID:
01587395
Message ID:
01587396
Vues:
89
This message has been marked as the solution to the initial question of the thread.
>I need to copy my DBF to an ascii text file and recover it later on.
>
>The method i am using now is COPY TO (filename) type deli
>
>and then APPEND FROM (filename) using an empty table structure.
>
>However the deleted records are not being marked as deleted in the ascii file.
>
>How do I COPY TO / APPEND FROM to take care of the deleted records
>
>OR
>
>is there another way altogether


If you need it in a text file:
ALTER TABLE myTable ADD COLUMN lDeleted
REPLACE ALL lDeleted WITH DELETED()
COPY TO output.txt DELI

* Then later:
APPEND FROM output.txt DELI
DELETE ALL FOR lDeleted
ALTER TABLE myTable DROP COLUMN lDeleted
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform