Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Convert from dbf to text
Message
De
19/08/2007 09:27:46
 
 
À
19/08/2007 09:19:58
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01249004
Message ID:
01249005
Vues:
23
>hi all,
>
>i try to convert dbf to text file as this code,
>
>
>
>CLOSE all
>thisform.text1.value=GETFILE('dbf')
>USE alltrim(thisform.text1.value) in 0
>
>gcDelimName = ALIAS( ) + '.txt'
>gcDelimFile = PUTFILE('text_file:', gcDelimName, 'txt')
>IF EMPTY(gcDelimFile)
>   CANCEL
>ENDIF
>COPY TO (gcDelimFile)    && Create not delimited file
>COPY TO (gcDelimFile) TXT  && error
>SET DEFAULT TO d:\yousef
>
>
>thanks

Check the help for the COPY TO command. There is no TXT option. You probably want something like:

COPY TO (gcDelimFile) DELIMITED WITH "" WITH BLANK
VFP Help:

COPY TO FileName [DATABASE DatabaseName [NAME LongTableName]]
   [FIELDS FieldList | FIELDS LIKE Skeleton | FIELDS EXCEPT Skeleton]
   [Scope] [FOR lExpression1] [WHILE lExpression2] 
   [ [WITH] CDX ] | [ [WITH] PRODUCTION ] [NOOPTIMIZE] 
   [ [TYPE] [ FOXPLUS | FOX2X | DIF | MOD | SDF | SYLK | WK1 | WKS | WR1
   | WRK | CSV | XLS | XL5 | DELIMITED [ WITH Delimiter | WITH BLANK 
   | WITH TAB | WITH CHARACTER Delimiter ] ] ] [AS nCodePage]
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform