Zeoslib Portal

I use zeos 7.0 (last svn) in lazarus (0.9.31)

when i make a query like

select -1.25 as num

and i want to show in lazarus. display always positive ( 1.25 ). This onlye in real numbers.

The problem is Zeos, i used PQconecction and works ok.

any idea?

cpalx,

which engine do you use here? PostgreSQL?

Michael

Try do this with stranded Lazarus components

Or replace . on ,

Better execute in this http://www.sqlmanager.net/en/products/p ... ql/manager

ism wrote:

Code: Select all

select -1.25 as num

Try do this with stranded Lazarus components

Or replace . on ,

Better execute in this http://www.sqlmanager.net/en/products/p ... ql/manager

This bug do exist - simple test case:
Put ZComponent and ZQuery on a form. Configure Your pgsql connection.
Enter Query text just like cpalx wrote: "select -1.25 as num
and then do:
ZQuery1->Active = true;
double tmp = ZQuery1->FieldByName("num")->AsFloat;
ShowMessage(FloatToStr(tmp));
ZQuery1->Active = false;

in CBuilder2010 on postgresql 9.0 i got message "1.25" - positive value

You have done what I wrote?
Results ?

Sorry guys, wasn't at home.

Patch done Rev.1125\testing and Rev.1126\tesing-egonhugeist

5min work... Confirmed?

Michael

It does work better;)

markus,

??? What you mean here?

no no - before Your patch...
i didn't see Your post

With rev 1126 this problem is gone

Thanks.