User bio
404 bio not found
Member since Dec 11, 2015
Posts:
Replies:
Hi and thanks for your reply!
Since this is not a stored procedure in Iris database but in an MS SQL server, syntax does not work
"SELECT PackageName.ClassName_ProcedureName ('parameter')"
Normal call is Execute procedure name.
For example, when I call a procedure that does not use an output parameter, I use
"..Adapter.ExecuteQuery (.tResult, tQuery) Quit: $$$ ISERR (tStatus)"
However, because this procedure fills an output parameter, this call does not work. It then returns "Error! Function must return a value". So i suppose i need to use
Sincerely, Michael
Thanks for this. Exactly what i was looking for
/Michael
Certifications & Credly badges:
Michael has no Certifications & Credly badges yet.
Global Masters badges:







Followers:
Michael has no followers yet.
Following:
Michael has not followed anybody yet.
***Solved***
s SQLQuery = "{call TheProcedure }"
s tSC = ..Adapter.ExecuteProcedure(.theResponse , ,SQLQuery)
s tSnapshot = theResponse.GetAt(1)