Zeoslib Portal

Hello Jan,

nothing happens. It looks like the query went fine but no effect to any other queries.

Petr

Hi, I use Lazarus and FreePascal under Ubuntu 12.04. Because of missing features (transaction support for MySQL) I decided to move to ZeosLib. So far so good but I've found something I don't know what to do. When I used internal FPC and Lazarus components, I could do something like this: q.SQL.Text ...

if I try Q.Connection.AutoCommit := False and do Q.Connection.StartTransaction I get "error invalid operation in non AutoCommit mode" so I don't call StartTransaction when AutoCommit is False and call only Commit after all data are inserted. When AutoCommit is true, I can call Q.Connection...

Hello Michael, thank you for your help. Maybe I've found a workaround. According to SQLite documentation, it waits after every query to full sync. So before insert of lots of records, it's better to turn off the sync and turn it on back after the operation. try Q.SQL.Text := 'PRAGMA synchronous=0'; ...

Hello, I'd like to insert a few records into SQLite3 database but it takes very long time. It seems it saves every record one by one because I can hear that my HDD works vey hard :). The code is: const C_INS = 'insert into nastdiety(stat,dieta) values(%s,%d)'; try try Q.Close; Q.Connection.StartTran...

Hello,

I just downloaded from SVN (trunk) and installed zeos db components to Deplhi XE2. It works but all fields defined as TEXT in sqlite database has in dbeEdit fields "widememo" text and not the correct value. Anyone knows what could be wrong, please?

Thank you!

Petr