Zeoslib Portal

Hi All, Think I Found where the bug is... But I dont know how to send the correction.. ( can anyone help/teach me me ?) so, I'm sendind the simple change I did on ZStoredProcedure.pas: procedure TZStoredProc.SetStatementParams(Statement: IZPreparedStatement; ParamNames: TStringDynArray; Params: TPar...

TZStoredproc or TZQuery does not execute when there are params with NULL values fith Firebird, raising "parameter mismatch" error.

Hi all,

I did test Mark's suggestion but it didn´t work also.
Passing -1 as a param is not a solution for me cause it won´t work in othe procedures.
So, problem the persist

Thanks...

Jennecy

Hi all, thanks Mark for your reply. yes i'm sure it should work as it is... it works with Delphi's ADO components, MDO Firebird components, Delphi's IBX and so on. I could choose to work with MDO, but it works only with Firebird, and I'd like to be working with more than one DB. Any other idea ? I l...

Hi all, I am migrating a system from DELPHI + ADO + SQL Server to DELPHI + ZEOS + Firebird, and there are Stored Procedures with parameters that may need to be NULL, e.g. "execute procedure test 1, NULL, 'testing', 2, 9" The problem is that the aplicatiion is setting parameters values corr...

Hi again this is the Stored Procedure definition: Create or alter Procedure stoproc_Artista (Operacao int, Chave int, Nome varChar(50), Autor char(3), Compositor char(3), Arranjador char(3), Orquestrador char(3)) returns (result int, Codigo int) As BEGIN IF (:Operacao = 0) then BEGIN DELETE FROM IAS...

Hi jennecy, could you please attach an example code (with the definition of the StoredProc that causes the exception)? This would be very helpful. Thanks! First of all, thanks Michael for the attention and sorry for the long time taken to reply... :-) this is the part of code you asked for: procedu...

Hi all, I am migrating a system from DELPHI + ADO + SQL Server to DELPHI + ZEOS + Firebird, and there are Stored Procedures with parameters that may need to be NULL, e.g. "execute procedure test 1, NULL, 'testing', 2, 9" The problem is that the aplicatiion is setting parameters values corr...