Good day
My code looks like this:
var string = "DECLARE @NOTEOUTPUT VARCHAR(8000) Exec PARSE_SCRIPT '"+data+"', "+caseid+", 1, @Noteoutput output select @noteoutput as documentOutput";
var mySQL = string;
var myQuery = CRM.CreateQueryObj(mySQL,"");
myQuery.SelectSQL();
Response.
data= myQuery("documentOutput")
I get the following errors:
eWare.eWareQuery error '8000ffff'
[SafeCall Exception]: field documentOutput not found
/crm/CustomPages/Cases/CasesPDFApproval.asp, line 26
When I run the query in SQL management studio I do get a result with one row and one column.
I do not understand what I am doing wrong.
Please assist.