Zeoslib Portal

I haven't checked but i think that when you use the .AsString method it uses the 'Short Date' format specified by windows (Held in SysUtils?) Try using the .AsDateTime to get a datetime value and then use the (SysUtils) FormatDateTime function to convert that into a string with the formatting parame...

This may help.

http://zeos.firmos.at/viewtopic.php?t=1317

I don't know firebird at all. The link below has an example of casting time/date types in firebird.

http://www.firebirdsql.org/index.php?op ... stenried_1

Although this isn't an answer to your problem it is related to using dblib. This is a quote from the microsoft forum: Although the SQL Server 2005 Database Engine still supports connections from existing applications using the DB-Library and Embedded SQL APIs, it does not include the files or docume...

Out of curiosity why isn't firing a seperate 'select count' with the same from/where part an acceptable solution?

What database are you using? (MSSQL, Postgres, etc.)

Put your parameters to connect to the database in the databse property of the TZConnection.

e.g.
zConnection1.Database := 'Provider=SQLOLEDB.1;Password=XXXX;Persist Security Info=True;User ID=SA;Initial Catalog=MLMH;Data Source=ANDROMEDA'

The libpq.dll loads other dll files. In Version 8.1 of Postgres libpq.dll relies on the following dlls: comerr32 libeay32 libintl-2.dll libiconv-2.dll krb5_32.dll ssleay32.dll Applications written with Borland Developer Studio 2006 is not reporting the error messages when libpq.dll fails to load the...

DBCommonTypes should be in

$(BDS)\source\Win32\db

$BDS is your installation folder for Borland Studio

I'm using Delphi 2006 and versoin 6.5.1 zeos with Posgres V8.1. Zeos reports that it can't find either libpq81.dll or libpq.dll when I try connecting to the server. Stepping through the code shows that loadlibrary is not returning a handle. I wrote a test appication to see what was happening. I spec...

Hi Shomar, You don't say how you are connecting across the internet. You need to make sure tha you have a route configured between the client and server. Have you got your gateway addresses set correctly, if you are using a proxy have you got the correct proxy type configured and using the correct u...

I'm not quite sure if I've misunderstood what you have done with the ZConnection.GetTableName(). The 'Pattern' you pass is used to find matches on the table names. If you pass in an empty string you get a full list of tables. If you need to find a single table eg. a table called 'employees', set the...