Information générale
Catégorie:
Codage, syntaxe et commandes
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement