Zeos 7.1.3 Sybase ASE 15.5 TZStroredProc

The stable tester's forum for ZeosLib 7.0.x series

Report problems concerning our Delphi 2009+ version and new Zeoslib 7.0 features here.
Post Reply
Sebastien
Fresh Boarder
Fresh Boarder
Posts: 2
Joined: 07.05.2015, 14:37

Zeos 7.1.3 Sybase ASE 15.5 TZStroredProc

Post by Sebastien »

Hi,

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
The table TMP :

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
The TZStoredProc don't send the correct values for parameters.
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).
Post Reply