>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?
Are you missing spaces where the lines join?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer