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 '<<tcErrText>>'
ENDTEXT
This.mExecutesqlCommand(lcSql, '', '')
...
if I use lcSql = "usp_UpdateErrors '" + lcErrText + "'" instead
then everything is fine.
Any idea?
Thanks