Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Textmerge problem
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Textmerge problem
Divers
Thread ID:
00249336
Message ID:
00249336
Vues:
55
I am cheating and using VFP to write an SQL script for a non-compatable version of another database. I am parrsing the data from a text file, and making the script via textmerge as per the code below

SET TEXTMERGE ON NOSHOW
STORE houtfile TO _TEXT && yes, houtfile is open!

DO WHILE NOT FEOF(hinfile)

&& get variable values from infile

&&The section below is what needs to be put into a scipt,quotes and all
\INSERT INTO "_SMDBA_"."_INVSRVHIST_"("ACTION","ITEM")
\\VALUES(<>,(SELECTInventory_Items."Sequence" AS "seq.InventoryItem"
\ FROM "_SMDBA_"."Inventory Items" Inventory_Items
\WHERE
\ Inventory_Items."Configuration ID" = '<>' AND
\ Inventory_Items."Part Description" LIKE 'pentium%'));
\
LOOP

It will not complile, as the sql statements are 'invalid', even though they should be read as staight text after the delimiters, and not as sql statements. I must have the quotes exactly as in the sample in order for this script to run on the external db.
Any suestions on how to get it to work?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform