Recent posts:
Halim has not published any posts yet.
Recent replies:

Hi There

I think it would be much easier to achieve what you are looking for by adding a custom process ( that includes your rules/logics using the code) between the service and the operation  and then the operation sends the response to the process.

If you need more help, please let me know

Thanks

Yes, I had the same issue.

Some sql ODBC adapters accept the double quotes, some not, it's safer to remove them.

All the best.

Hi Ewan,

Yes, it's possible to call a SP from an sql server, we use it a lot and it works fine.
Yes, it returns an Integer but usually that's not the result returned by the SP

the result is in %sqlcontext, I use it like this :

ClassMethod GetApptsSP(URNO As %String = "3123456") As %Status
{

  // calling the SP 
    set status = ##class(Hospital.SP.tpGetAppts).tpGetAppts(URNO)
 

   s rs=%sqlcontext.NextResult() // getting the result
    While rs.%Next() {

        s dateTime = rs.%Get("DueTimestamp")
        s ApptDate = $P(rs.%Get("DueTimestamp")," ",1)
     ....

}

 q $$$OK

}

hope this help

Followers:
Halim has no followers yet.
Following:
Halim has not followed anybody yet.
Global Masters badges: