Zeoslib Portal

Bye Bye Zeos
Testing SQLdb

Thank you Silvio Guedes

This problem not it happens only on posgresql, in the Firebird too
I believe that the problem is in the Zeoslib

Lazarus 0.9.10 (for Windows and Linux) + Firebird 1.5 + ZeosLib 6.5.1

My table it consists a field "DATACADASTRO TIMESTAMP NOT NULL" In the Lazarus when inserting a register I use following code: TQuery.FieldByName('DATACADASTRO').AsDateTime := Date; But when I load it the register (select * from table), to return an error because of the date that was saved....

Sorry a long time
Nicola,

I tested the parameter IDVENDEDOR and is correct, but some suggestion?

tkszeos , Thank you But I am with my first error: Executing second time the ZStoredProc, return this erros: SQL Error: Dynamic SQL Error parameter mismatch for procedure CALCID_VENDEDORDETAIL. Error Code -902. Unsuccessful execution caused by a system error that precludes successful execution of su...

I am obtaining results, reading the Knowledge Base: An introduction to the basic usage of ZeosLib DBOs and Firebird basics But my ZConnection is AutoCommit=True and this is my code: ZStoredProc.ParamByName('IDVENDEDOR').AsInteger := ZTable.FieldByName('IDVENDEDOR').AsInteger; ZConnection1.StartTrans...

Sorry a question, but I am making this: In ZQuery1.SQL: execute procedure CALCID_VENDEDORDETAIL :idvendedor In Unit: ZQuery1.ParamByName('IDVENDEDOR').AsInteger := StrToInt(Edit1.Text); ZQuery1.ExecSQL; When I execute, returns this error: SQL Error: message length error (encountered 0, expected 8) E...

It looks at the code below: [hr] uses Classes, SysUtils, LResources, Forms, Controls, Graphics, Dialogs, DBCtrls, ColorBox, ComCtrls, ExtDlgs, Calendar, EditBtn, FileCtrl, XMLPropStorage, ZConnection, ZDataset, DB, DBGrids, Menus, ActnList; ... ZTable.First; [fade] ZTable.FindRecord(TreeView.Selecte...

I am using Interbase 6 + Lazarus, but I go to try exactly thus

Well, I am not creating the ZStoredProc in run-time. Executing some tests I evidenced that it does not have errors in Store Procedure. Executing second time the ZStoredProc, return this erros: SQL Error: Dynamic SQL Error parameter mismatch for procedure CALCID_VENDEDORDETAIL. Error Code -902. Unsuc...

While I execute my store procedure in second time, result a error.

e.g:
ZStoredProc.ParamByName('IDVENDEDOR').AsInteger := ....
ZStoredProc.ExecProc;

But if i exit the project and return, normal functioning of the SP, what I am not remembering to make?