Zeoslib Portal

Hello Jan.

I will try your suggestion.

It is strange, when AutoCommit is false InTransaction is true, so I can not call StartTransaction. Well I will see in a test application how it works.

Kind Regards.

Hello Jan, I am sure you are right. Could it be this way ? ZConnection.AutoCommit := true; ZConnection.Connect; // Connect and start transaction => InTransaction = False ZConnection.ExecSQL('insert into exampletable (ID, FIELDNAME) values (1, ''Test'')'); // Execute and due to AutoCommit = true comm...

marsupilami,

Your patch is working fine, and the exceptions are being raised properly.

I have forgotten of compiling the Zeos components, that's why the application was not raising any exception.

Kind regards

Hello marsupilami, Exactly, InTransaction is responsible for tell if there is an active transaction or not. I do not agree on the way Zeos has implemented the transactions blocks. What the AutoCommit parameter stands for ? I think, IMHO, that when you set it to true after every call to the Post or D...

Hello marsupilami,

I am not sure because no exception was raised when I have pressed the delete button of my application, although the record was not deleted.

Kind regards.

Hello marsupilami,

As a matter of fact I am not whitin a transaction, I have just connected to the SQLite database.

The TZConnection::AutoCommit is set to false and I have not started an explicit transaction, so I can not undrstand why the SQL commando does not work.

Kind regards.

I strongly disagree. When you connect to a database there ara no any transaction in course, just the connection was made. Have a look on the Borland CBuilder / Delphi help file and look for the InTransaction property. You will see that InTransaction is true in the following situations : 1. AutoCommi...

Hello, I am using Zeos to connect to a SQLite database ( protocol=sqlite-3 ). According to SQLite website http://www.sqlite.org/pragma.html#pragma_foreign_keys SQLite do not enable foreign keys by default, we need to enable it on every connection running a SQL command "PRAGMA foreign_keys = ON&...

Hello, I have given a look in ZConnection.pas file and I found the GetInTransaction function definition : {** Checks is the connection started a transaction. @returns <code>True</code> if connection in manual transaction mode and transaction is started. } function TZConnection.GetInTransaction: Bool...

Hello, I have changed the SQL query to: SELECT evt.EVENTO FROM EVENTO evt WHERE strftime("%Y-%m-%d %H:%M:%f",evt.DATAHORA,'localtime') = strftime("%Y-%m-%d %H:%M:%f", :dthr ,'localtime') AND evt.UNIDADE = :unid and evt.TIPO_EVENTO = :tpevt Now I am binding the "dthr" pa...

Hello, I am using TZConnection to connect to a SQLIte database using sqlite-3 protocol. The value of TZConnection::InTransaction property is always set to true, even just after opening the connection without performing any database command. Is this a SQLite issue ? AutoCommit=false and TransactIsola...

I am still using the locate method, which works fine. I have found a clue of the problem. I have defined the field "DATAHORA"as timestamp, and there is not this kind of data type on SQLite. I need to store timestamp values, so I have changed the column type to DATETIME. It might be solved....

Thank you for answering. I will give it a try. I have made some changes which are giving me the proper result. I have eliminated the date comparison, so I have got more than one row. The Locate method works fine passing the value to search for as DateTime. I am afraid it is not a SQLite problem beca...

Hello, I am a little bit new at SQLite. I have created a SQLite table as follows: Create table IF NOT EXISTS EVENTO ( EVENTO INTEGER NOT NULL PRIMARY KEY , DATAHORA Timestamp(3,3) NOT NULL , MODULO INTEGER, UNIDADE INTEGER NOT NULL, TIPO_EVENTO INTEGER NOT NULL, ) ; I have inserted a record with the...

Never mind. I have got it by myself.

Thank you very much.