Zeoslib Portal

Hello Michel, I notice that my datatype was DOUBLE (not LONG), then I do this change... Its work ok. (7.1.2-stable). I think is better to see with AVZ why this dont work... case SQLCode of SQL_TEXT : EncodeString(SQL_TEXT, Index, Value); SQL_VARYING : EncodeString(SQL_VARYING, Index, Value); // SQL_...

Yes, Its Firebird 2.5.3 I Updated to 7.1.2-Stable... I did the same test and the problem appear too. Its not solved. ----------------------------------------- Inspecting Zeos Code, I think that occur in : GetPlainDriver.isc_dsql_execute2(@FStatusVector, GetTrHandle, @StmtHandle, GetDialect, FParamSQ...

Solved.

good work.

Thanks...


Today I UPDATED to 7.1.2-stable (Solved too)

With Zeos 7.0.5 (today release) --------------------------------2013/9/8 22:40:10-------------------------------- This application has leaked memory. The small block leaks are (excluding expected leaks registered by pointer): 5 - 12 bytes: TZCppCommentState x 10, TZQuoteState x 10, TZNumberState x 1...

Inspecting my code I notice some Memory Leaks: Delphi: XE3/32 or Delphi 2007 (the same) FastMM4 4.991; Zeos: 7.0.4; Its simple to test: with TZConnection.Create(Self) do try Protocol := 'firebird-2.5'; HostName := 'localhost'; User := 'sysdba'; Password := 'masterkey'; Database := 'c:\dados\store_pa...

Solved.

A basic mistake. One thread was not commiting record.
When another thread enter a lock conflict at record .

Thanks.

Hello, thaks for your help, first of all. I created this test case. For my surprise this test case work fine. Now I will rework my job to find where is the problem. Thanks for your attention. -----------------------------xxxxxxxxxxxxx-------------------------------- uses zConnection, zDataset; { TAB...

Delphi XE3
Zeos - 7.0.4

I create a connection for each thread and free at the end.
It work ok with select, but crash with execSql.

Crash occurs in this point (ZAbstractRODataset -line 1660)
FRowsAffected := Statement.ExecuteUpdatePrepared;

Today, I test you sugestion with 7.0.4.... (fbclient.dll 2.5.3 )
The problem continue the same.

Using version 7.0.4, or 7.2 - has the same behavior: I have a RESTful server (using indy httpserver). For each client I create a connection to the database (Firebird 2.5.3 - 64bit) to isolate the database access for each client. Everything works fine when I asked to "select" command (TzQue...

/* CREATE TABLE CTPROD_ATALHO_TITULO ( CODIGO DOUBLE PRECISION NOT NULL, NOME CHAR(20), PRIORIDADE DOUBLE PRECISION ); insert into CTPROD_ATALHO_TITULO (codigo,nome) values (3,'TEST'); */ db := TZConnection.create(self); db.Protocol := 'firebird-2.5'; db.User := 'sysdba'; db.Password := 'masterkey';...

On database you can use triggers. With delphi you can use TZUpdateSQL to intercept insert, update, delete records. Maybe with some hack of TZUpdateSQL you be able to do something like to update two tables.

it was code in FB 3.0 as you can see at http://asfernandes.blogspot.com.br/

There are no way to connect to firebird without an exists database. Everything firebird need to run are in one file. After 2.0 they include some security apart, but as a known, there are no way to access or link user to database. You can use except to do that or test with fileexists(...), before con...