Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
COPY memo fields to txt file
Message
De
15/03/2015 17:07:25
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
 
 
À
15/03/2015 16:47:24
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01616834
Message ID:
01616835
Vues:
41
>Hi All:
>
>I am passing data from VFP tables to a programmer, by COPYing DELIMITED to a text file. He then imports the data from the text files into SQL Server.
>
>I notice, however, that the COPY command does not copy memo fields. How do I do that?
>
>Thanks,
>
>Yossi

The problem is that a memo could contain stuff that will corrupt a DELIMITED, or any other line based format

One problem (just an example)

Those text formats are one line - one record. If a memo contains a line break, how should that be handled? Also a single memo could be a bit large

I would try to use XML to transport the data, the other guy should be able to deal with it.


HTH

Lutz
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform