On Fri, 2006-06-30 at 18:25 +0200, Zlatko Matić wrote:
> I have big problem with displaying results from a query, by using
> Postgres 8.1.X, TPQConnection, TSQLQuery and TSQLTransaction. I think
> that something is very wrong with SqlDB components...Values in some
> columns are not displayed at all, or are displayed incorrectly (zero
> insted of actual numerical value, the same datetime in all timestamp
> fields etc., empty cells in some varchar columns etc.).
> I tried with different queries and it is always the same: values in
> some columns are displayed correctly, while other columns are empty or
> with wrong values. It is not related to field's type, because some
> fields are correctly displayed while others are not, although having
> the same type.
> I tested also on the other computer and there was the same result.
> Win XP SP2, PostgreSQL 8.1.2 and PostgreSQL 8.1.4; encoding: WIN1250,
> recent Lazarus snapshots, as well as with current official Windows
> binary.
> Just for record, all the queries are previously tested on pgAdmin
> and MS Access front-end and are working without any problems on those
> platforms...
>
> Do you have any idea?
Which version of fpc are you using? If you want to use postgres for
real, you should use 2.0.3 or 2.1.1 from a recent date.
Joost.
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
