Stored Procedure Return 1

[daikos]

Good evening folks.

I have an Stored Procedure in my database that returns only one integer but how do I "get" this result/return in Clarion?

I have tried many ways like:

Dummy{PROP:SQL} = 'select last_client();'
Dummy{PROP:SQL} = 'call last_client();'
Dummy{PROP:SQL} = 'select * from last_client();'
Dummy{PROP:SQL} = 'select last_client from last_client();'

But still don't work.

Best regards.

 

[ShankarJ]

Hi!


RetVal LONG


BIND('RetVal', RetVal)

Dummy{PROP:SQL} = '&RetVal = CALL dbo.last_client();'

or

Dummy{PROP:SQL} = '&RetVal = NORESULTCALL dbo.last_client();'

IF NOT ERRORCODE()
! process value in RetVal
END

Read more on "Using Embedded SQL" in the help.

Regards

 

[daikos]

Thanks ShankarJ!

Works great as always.

Best Regards.