#define CRLF CHR(13)+CHR(10)

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