Zeoslib Portal

Hi! 1. Is it possible to execute multiple INSERT INTO table (fields) VALUES (..), using Zeoslib and how? 2. I have a procedure which dynamically creates SQL string "INSERT INTO" and executes it for every row seperately. If I generate SQL strings first for all rows and the execute multiple ...

Your ZeosLib DBO Version: trunk The IDE you are using: Lazarus Version (and maybe patchlevel) of the IDE: The database you are using: Firebird Version of the database: Used protocol: [hr] Error description and post Hello. Is there a way to use Zeoslib ZQuery component for querying different dataset...

Hello, mdaems! Thanks for good will, but it is not necessary, because I received the answer that solved the problem, from a local Croatian Delphi newsgroup. The solution is quite simple: I just had to remove all "IS NULL" comparisons in WHERE clause of ModifySQL. Therefore, the new ModifyS...

Hello, Lazarus, Zeoslib, Firebird. I was trying to make a ZQuery updateable, by providing a ZUpdateSQL. Unfortunately, it doesn't work in my case. When trying to update a row, I get the following error: “SQL error. Dynamic SQL error SQL error code= -804 Data type unkown. An error was found in the ap...

Hello, Lazarus, Zeoslib, Firebird. I was trying to make a ZQuery updateable, by providing a ZUpdateSQL. Unfortunately, it doesn't work in my case. When trying to update a row, I get the following error: “SQL error. Dynamic SQL error SQL error code= -804 Data type unkown. An error was found in the ap...

Hi!
1. What is the difference between ApplyUpdates and CommitUpdates?
2. If cahced updates inserts row by row, is there any other way to insert rows in a batch?

Regards,

Zlatko

Hi! In fact, I was trying to batch insert data from a .csv file to a PostgreSQL table, by looping through both datasets and appending rows from .csv file to PostgreSQL table. The following code works: procedure TForm1.ButtonImportOrdersClick(Sender: TObject); begin //Start transaction? //ZConnection...

Hello.
Could someone point me to direction how to insert many records in one operation (batch insert) to PostgreSQL, using Lazarus and Zeos?
I would appreciate an example.
Thanks.

Thanks.
Anyway, Locate is just good enough for most purposes, I think.

Regards,

Zlatko

Lazarus+Zeos+PostgreSQL.
It seems that I can't use SetKey, GotoKey, GotoNearest; FindKey, FindNearest in for searching values in a table?
Are there alternative methods for performing searches in a TZTable?
Thanks,

Zlatko

I installed Zeos 6.6.1 Beta in Lazarus 0.9.22 (FPC 2.0.4), on Windows XP and successfully connected to PostgreSQL in design time. I got results in DBGrid successfully. But, when I try to compile the project I get the following error: "Unit1.pas(9,3) Fatal: Can't find unit ZConnection", so ...