>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 + "'"
?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.