I have created a stored procdure name sp_GetInfoCurrency and the codeing as bellow:
CREATE PROCEDURE [dbo].[sp_GetInfoCurrency] @pcurcode nchar(5), @pcurid int output, @pcurname nvarchar(50) output, @pcurrate smallmoney outputASBEGIN SET NOCOUNT ON;
select @pcurid=curid, @pcurname=curname, @pcurrate=currate from currency where curcode=@pcurcode if @pcurid is null begin set @pcurid=0 set @pcurname='' set @pcurrate=0 endEND
My question is, How to call the stored procdure through StrataFrame, Is there any method or fuctions easy to do this? Please provide the sample code.
Thanks.