>Help, I’m trying to add a record using macro substitution. All works fine until I place a carriage return to the data being saved. Now it falls over with “syntax error” when using EXECSCRIPT() or “command contains unrecognized phrase/keyword” when using macro substitution. Can anyone help resolve this problem, please. I show below code that has the problem.
>
>VFP9; XP Prof
>
>IF !FILE('c:\temp\test.dbf')
>CREATE TABLE c:\temp\test (nVal I autoinc, cText C(30), mText M)
>ENDIF && FILE('c:\temp\test.dbf')
>
>lcFldList = "cText, mText"
>lcFldVal1 = "Text"
>lcFldVal2 = "Line 1" + CHR(13) + "Line 2"
>lcTbl = "c:\temp\test"
>
>lcInsertStr = "INSERT INTO " + lcTbl ;
> + " (" + lcFldList + [) VALUES("] + lcFldVal1 + [","] + lcFldVal2 + [")]
>?lcInsertStr
>
>TRY
>*!* &lcInsertStr
>EXECSCRIPT(lcInsertStr)
>CATCH TO loErr
>MESSAGEBOX("lcInsertStr failed" + CRLF + lcInsertStr + CRLF + loErr.message, 0, "Info")
>ENDTRY
>
>TIA
>Gordon

Gordon,

lcFldList	= "cText, mText"
lcFldVal1	= '"Text"'
lcFldVal2	= '"Line 1" + CHR(13) + "Line 2"'
lcTbl		= "c:\temp\test"

lcInsertStr	= "INSERT INTO " + lcTbl ;
	+ " (" + lcFldList + [) VALUES(] + lcFldVal1 + [,] + lcFldVal2 + [)]

However an insert into doesn't need an execscript to prevent a macro subsitution. It's an overkill IMHO.

insert into (m.lcTbl) (&lcFieldList) values (m.Val1, m.Val2 ...)
is even better.
Cetin