Dear All
I use my own SQL stored procedures using the CALL command sending the parameters from clarion and getting results and everything was fine.
now we have a third party stored procedure with a lot of parameters and calling the stored procedure using the variable definition.
this a simple example to clear my case:
To execute from sql
so the parameters are not sent in order, what I need is to get the OUTPUT parameter using this method of sending parameters from Clarion.
thank you all in advance.
Regards
I use my own SQL stored procedures using the CALL command sending the parameters from clarion and getting results and everything was fine.
now we have a third party stored procedure with a lot of parameters and calling the stored procedure using the variable definition.
this a simple example to clear my case:
Code:
create PROCEDURE sk_test5 @aa nvarchar(30)=NULL
, @bb nvarchar(30)=NULL
,@result nvarchar(30) = NULL OUTPUT
AS
select @result = @aa + @bb
GO
To execute from sql
Code:
@Result and @myResult should be nvarchar(60) (declaration is not saved in this note.. dont know why)
exec sk_test5 @bb='--Para2--',@aa='--Para1--',@Result = @myresult OUTPUT
select @myresult AS Result
so the parameters are not sent in order, what I need is to get the OUTPUT parameter using this method of sending parameters from Clarion.
thank you all in advance.
Regards