>>I am using TEXTMERGE to create SQL commands. I am trying to use it in an Automation Server that's called from an ASP page. Something strange. If I use it in my error method then line of code after it is not executed.
>>...
>>lcErrText = MESSAGE() + ' ' + cMethod + ' ' + STR(nLine)
>>TEXT TO lcSql TEXTMERGE NOSHOW
>> usp_UpdateErrors '<>'
>>ENDTEXT
>>This.mExecutesqlCommand(lcSql, '', '') && is not executed
>>...
>>if I use lcSql = "usp_UpdateErrors '" + lcErrText + "'" instead
>>then everything is fine.
>>Any idea?
>>
>>Thanks
>
>Hmmm,
>Did you see the difference between:
>usp_UpdateErrors tcErrText (with <<>> around tcErrText)
>and
>"usp_UpdateErrors '" + lcErrText + "'"
>?
I think I got code sample wrong:
TEXT TO lcSql TEXTMERGE NOSHOW
usp_UpdateErrors '<>'
ENDTEXT
Here how it should be.