Zeoslib Portal

Very thanks Seawolf!!.
working properly

How to get a return value from a stored procedure using the component tzreadonlyquery? ........ sp.ParamByName('turno').AsInteger := 0; sp.ParamByName('fehora').AsString := 'x'; sp.ParamByName('codusuario').AsInteger := 99; ........ sp.ExecSQL; the store procedure is: create or alter procedure ADD_M...

with autocommit=true or false is the same

separate logs: using TZReadOnlyQuery: 2010-02-09 11:12:30 cat: Connect, proto: firebird-2.1, msg: CONNECT TO "D:\lz\resto\resto.fdb" AS USER "SYSDBA" 2010-02-09 11:12:30 cat: Transaction, proto: firebird-2.1, msg: TRANSACTION STARTED. 2010-02-09 11:12:35 cat: Prepare, proto: fire...

Hello.. This is the log. First run the TZReadOnlyquery, then the TZStoredProc.. and crash!! 2010-02-09 10:48:53 cat: Prepare, proto: firebird-2.1, msg: Statement 1 : EXECUTE PROCEDURE AGREGAR_MESA (?, ?, ?, ?, ?, ?) 2010-02-09 10:48:53 cat: Bind prepared, proto: firebird-2.1, msg: Statement 1 : 1,0,...

The component TZStoredProc not working properly. if I use the component TZReadOnlyQuery not get the error -501: Configuring this parameters in this component: connection: the connection params: (add 6 params) sql: EXECUTE PROCEDURE AGREAR_MESA (:codigo, :total, :codmozo, :impresa, :serie, :comp) the...

Hello seawolf..
not work!! the same error...

Hello.. Y work with lazarus (Lazarus 0.9.29 r23650 FPC 2.5.1 i386-win32-win32/win64), zeos 7 (revision 788) and firebird 2.1.3. I have a store procedure that inserts a record. Works well using IBEXPRESS. In a form I have a grid that displays a table. There is a button to add records which opens anot...