Hi,
I am using the RDC to connect to MS SQL Server 2008, I have created a stored procedure with an input value and an output value.
Procedure is detailed below:-
The corresponding entry in the commands section of the config file is below:-
The stored procedure runs fine when executed in sql server manager
but i get the following error message in the B4a log when executing
Any ideas on what is going on?
Regards
I am using the RDC to connect to MS SQL Server 2008, I have created a stored procedure with an input value and an output value.
Procedure is detailed below:-
B4X:
ALTER PROCEDURE dbo.sp_Increment_CustomSerialNumber (
@OwnerCode varchar(10),
@Number int OUTPUT
)
as
BEGIN
--insert procedure body here
set @Number = (SELECT Serial from TblCustomerCustomSerialNumbers WHERE OwnerCode = @OwnerCode)
--inc the value
set @Number +=1
Update TblCustomerCustomSerialNumbers SET Serial = @Number WHERE OwnerCode = @OwnerCode
END
The corresponding entry in the commands section of the config file is below:-
B4X:
sql.kitting_getCustomDigits=DECLARE @return_value int,@Number int ;EXEC @return_value = sp_Increment_CustomSerialNumber @OwnerCode = N?,@Number = @Number OUTPUT; SELECT @Number as N'Number'
The stored procedure runs fine when executed in sql server manager
B4X:
DECLARE @return_value int,@Number int ;EXEC @return_value = sp_Increment_CustomSerialNumber @OwnerCode = N'ABB',@Number = @Number OUTPUT; SELECT @Number as N'Number'
but i get the following error message in the B4a log when executing
B4X:
java.sql.SQLException: Incorrect syntax near '@P0'.
Any ideas on what is going on?
Regards