Zeoslib Portal

EgonHugeist wrote:Hi, should be resolved by R4225 \testing-7.2

Resolved.

When no resultset, then ExecProc must be called, not Open, but IMHO that is the way it should be.

Regards,

Sorry to say that, but still have trouble with the output parameter. Actually, I have modified the previous SP with one input, one output parameters and no result set like that (note the comment on select): ALTER PROCEDURE [dbo].[test_sp1] @p1 int = 0, @p2 VARCHAR(16) output AS BEGIN SET NOCOUNT ON;...

It seems that the issue has been resolved. My test cases work as expected. Thanks a lot!

Kind regards,

Any stacktrace? Which lines did call RaiseTypeMismatchError before? Here is the invocation and the stack trace: procedure TForm1.Button4Click(Sender: TObject); begin ZStoredProc2.Params.ParamValues['@p2'] := 'abc'; ZStoredProc2.Active := True; end; --- Stack trace --- #0 fpc_raiseexception at :0 #1...

EgonHugeist wrote:Any stacktrace?
Which lines did call RaiseTypeMismatchError before?

AFAIR ZVariant.pas line 718 with Value.VType = vtRawByteString (line 690)
Funny thing is that with ZeosLib 7.1.4-stable there is no such error.

Hello there, I'm currently experiencing a problem with TZStoredProc calling a MSSQL stored procedure with an output parameter. Using Lazarus 1.7, FPC 3.1.1, i386-win32-win32, Zeos 7.2.1-rc (fpcdeluxe v1.4.0k for i386-win32), MSSQL 2008 (SQL Server 11.0.2100) The SP was defined as: SET ANSI_NULLS ON ...