Zeoslib Portal

If you are using a ZTable then: var i: Integer; begin for i := 0 to Ztable1.FieldCount - 1 do begin ...... Do stuff here with your fields ........ ...... ZTable1.Fields .FieldName ...... end; end; Hope this helps. BTW ZeosLib works in a very similar way to other TDataset descendents. If you look in ...

Errors relating to "Entry Point Not Found" are almost always fixed by removing duplicate files. It looks like you have an old copy of ZPlain.bpl somewhere in your path.

Regards,

Ben

Try adding a ZSQLMonitor to your application and logging your queries. It may be that zeos adds something before your query runs.

Regards,

Ben

Hi garoto_burns,

I'm almost certain it is a library problem. When you choose between postgresql-7 and postgresql-8 you'll change which dll you use, which in turn then rely on other libraries.

Regards,

Ben

I'm using libeay32.dll with a version number of 0.9.8.0 which seems to work with the libpq81.dll which comes with zeos.

You should be able to download updated versions at http://www.slproweb.com/products/Win32OpenSSL.html

Regards,

Ben

Silvio,

Just for completeness, what version of Zeos are you using?

Ben

The link to the 7z file gives:

Not Found

The requested URL /downloads/ZEOSDBO-6.6.0-beta.7z was not found on this server.

As I understand it you need to compile the following in order:

ZCore.dpk
ZParseSql.dpk
ZPlain.dpk
ZDbc.dpk
ZComponent.dpk

then Install the following:

ZComponentDesign.dpk

You also need to add the source folder to you search path.

Regards,

Ben

Use the TRvDataSetConnection instead. Been using it for years and works very well.

Regards,

Ben

This will need documentation.

I just looked on the Testing SVN branch to see if it had been done but can't understand the xml format. Any tips?

Regards,

Ben

Sorry meant ZSQLMonitor.

Regards,

Ben

Put a ZUpdateSQL on your datamodule and log the queries you are sending. Sounds like a good start to debugging your app.

Regards,

Ben

Does Firebird have system tables that allows you to look up details like these? That's how I'd find this in PostgreSQL.

Regards,

Ben

First things first, all tables should have a primary key. How else should an application refer to a record in an SQL database?? In the case of a table without a primary key, for an update, ZeosLib by default produces a WHERE clause which contains all the fields of the recordset i.e.: UPDATE table1 S...

I don't think Zeoslib supports BCD fields for any database. If you look in ZDbcIntfs.pas you'll see: TZSQLType = (stUnknown, stBoolean, stByte, stShort, stInteger, stLong, stFloat, stDouble, stBigDecimal, stString, stUnicodeString, stBytes, stDate, stTime, stTimestamp, stAsciiStream, stUnicodeStream...