Ok, I'll give that a try, thanks to you and Sergey.


>As Sergey suggested, use ?memvar, like this

>Text to msql1 textmerge pretext 1+2+4+8 
>   Insert into dli_testing..CATMaster (Category, DiffLetter, alc, Keyword, Keyword2, CorrectResp,
>       Script, Stem, RespA, RespB, RespC, RespD, ScriptTime, TestType, OrigItmId, EnterDate, Completed)
>       Values (?m.cat , ?m.diff , ?m.alc, ?m.keyword , ?m.keyword2 , ?m.correctresp,
>          ?m.script , ?m.stem , ?ALLTRIM(m.respa) , ?ALLTRIM(m.respb),
>         ?m.testtype , ?m.itmnum , ?DTOC(m.enterdate) , ?m.completed )
>Endtext
>ms1 = SQLEXEC(mconn,msql1)

>
>>Ok, found the problem - one of the strings has a contraction in it (didn't) which SQL is reading as a string ending. I've got to be able to store strings with contractions in it, it's an English test question - what's the best way to handle this?
>>
>>
>>It didn't like your code either.
>>
>>>It looks like you have forgotten INTO. Btw, your code will be much easier to write, read and debug if you use Text-Endtext, like this

>>>Text to msql1 textmerge pretext 1+2+4+8 
>>>   Insert into dli_testing..CATMaster (Category, DiffLetter, alc, Keyword, Keyword2, CorrectResp,
>>>       Script, Stem, RespA, RespB, RespC, RespD, ScriptTime, TestType, OrigItmId, EnterDate, Completed)
>>>       Values (<<m.cat>> , <<m.diff>> , << m.alc >>, <<m.keyword>> , <<m.keyword2>> , <<m.correctresp>>,
>>>          <<m.script>> , <<m.stem>> , <<ALLTRIM(m.respa)>> , <<ALLTRIM(m.respb)>>,
>>>         <<m.testtype>> , <<m.itmnum>> , <<DTOC(m.enterdate)>> , << m.completed>> )
>>>Endtext
>>>ms1 = SQLEXEC(mconn,msql1)

>>>>Hi gang
>>>>
>>>>I have the following code/commands
>>>>
>>>>

>>>> msql1 = "Insert dli_testing..CATMaster (Category, DiffLetter, alc, Keyword, Keyword2, CorrectResp," + ;
>>>>    + "Script, Stem, RespA, RespB, RespC, RespD, ScriptTime, TestType, OrigItmId, EnterDate, Completed)" + ;
>>>>    + " Values ('" + m.cat + "', '" + m.diff + "', '" +  m.alc + "', '" + m.keyword + "', '" +  m.keyword2 + "', '" +  m.correctresp + "', '" ; 
>>>>    + m.script + "', '" +  m.stem + "', '" +  ALLTRIM(m.respa) + "', '" +  ALLTRIM(m.respb) + "', '"   ;
>>>>    + >
>>>>    +  m.testtype + "','" + m.itmnum + "','" + DTOC(m.enterdate) + "', '" +  m.completed + "')"
>>>>ms1 = SQLEXEC(mconn,msql1)
>>>>

>>>>
>>>>It returns no error and no rows affected.
>>>>
>>>>What am I missing?