I have a problem with TZStoredProc and the params value send to Sybase.
My stored proc is :
Code: Select all
CREATE PROCEDURE dbo.TEST
@NUCAMP int,@RANGACT int,@SOC int,
@SOCPRT int
AS
BEGIN
insert into TMP values (@NUCAMP,@RANGACT,@SOC, @SOCPRT, getdate())
END
Code: Select all
create table TMP (
N_NUCAMP int Null,
N_RANGACT int Null,
N_SOC int Null,
N_SOCPRT int Null,
SYB_DATE datetime Null)
go
For example : no matter what values i set to the parameters (except null) the procedure recieve always 1,1,1,1.
If i use a TZQuery instead of TZStoredProc, the procedure recieve the good parameters.
I'm using Zeoslib 7.1.3, but i have the same behavior with 7.1.4, 7.2 and 7.3 (all from SVN repository).