Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Passing & \ ? from a parsed text file to SQL Server
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MS SQL Server
Divers
Thread ID:
00979484
Message ID:
00979492
Vues:
30
>I am trying to pass characters like '& \ ?' from a delimited text file to SQL Server. Two lines in the file look like this.
>
>2566| 3|BURG | Thomas && Chelsea
>2567| 3|ROBB | Summer && Perkins
>
>I am unable to even get the fourth field to evaluate in a variable when I parse the text file. My objective is to parse the file and insert the records line by line into a SQL2000 table.


In your example, VFP thinks the '&&' combination is the reserved char for inline comments.
It should work if you trap them and replace them (STRTRAN) with the equivalent CHR(38).


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform