General information
Category:
Coding, syntax & commands
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?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only