Zeoslib Portal

I found where is the problem. The .ParamCheck must be false; and then is OK. DM1.Qs1.ParamCheck:=FALSE; DM1.Qs1.Close; DM1.Qs1.SQL.Clear; DM1.Qs1.SQL.Add('CREATE PROCEDURE UPD_DOB (IPARAM INTEGER) AS BEGIN '+ ' UPDATE TABELA1 SET SALDO = :IPARAM; EXIT; END '); DM1.Qs1.ExecSQL; DM1.ZCs.Commit; Thanks.

DM1.Qs1.Close; DM1.Qs1.SQL.Clear; DM1.Qs1.SQL.Add('CREATE PROCEDURE UPD_DOB (IPARAM INTEGER) AS BEGIN '+ ' UPDATE TABELA1 SET SALDO = :IPARAM; EXIT; END '); DM1.Qs1.ExecSQL; DM1.ZCs.Commit; I use ZEOSDBO-6.6.3-stable LAZARUS FireBird Problem i is :IPARAM Program crashed in DM1.ZCs.Commit; Thanks How...

I try this

ln -s /opt/firebird/lib/libfbclient.so.2.0.3 /usr/lib/libfbclient.so.20

but not woking,


When I start my program I got this message;
libraries can't be found libfbclIent.so.20

I' m installed:
SUSE 10.3 64 bit PC
Firebird 2.0.3 AMD64
ZEOSDBO-6.6.3-stable.zip
fpc-2.2.2-20081005.i386(2).rpm
lazarus-0.9.27.16875-20081005.i386.rpm

When I start my program I got this message;
libraries can't be found libfbclIent.so.20

What sugestions
Thanks

I m using SS.
How register any events?

1) I put this in my Firebired base; CREATE TRIGGER "My_table_MSG" FOR "My_table" ACTIVE AFTER INSERT POSITION 0 AS beg POST_EVENT 'my_event'; end 2 I put ZConnection1 and ZIBEventAlerter1 and ZQuery1 on my form ZConnection1.Contected:=false; ZConnection1.AutoCommit:=true; ZIBEve...

and a subsequent call to starttransaction is not necesarry (and impossible). Many thanks for your help. Im put this rows in program and now working. Conn.AutoCommit:=false; Q1.Close; Q1.SQL.Clear; Q1.SQL.Add('INSERT INTO PLACILA(TEXT) VALUES( "TRALALA")'); Q1.SQL.ExecSQL; Conn.Rollback; M...

Conn.AutoCommit:=true; Conn.StartTransaction; Q1.Close; Q1.SQL.Clear; Q1.SQL.Add('INSERT INTO PLACILA(TEXT) VALUES( "TRALALA")'); Q1.SQL.ExecSQL; Conn.Rollback; every SQL statement is (auto)commited. and Rollback not worked. Problem is AutoCommit:=true; when I put this Conn.AutoCommit:=fal...

With AutoCommit set to True, every SQL statement is (auto)commited. When StartTransaction is executed then all statements are executed on the Commit.

I try programing with
linux,
Lazarus, and Firebird.

Zeos componet 6.6.1
Thanks.