[patch_done] An Error in zeos 7, last svn

[cpalx]

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?

[EgonHugeist]

cpalx,

which engine do you use here? PostgreSQL?

Michael

[ism]

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

[markus]

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

[ism]

You have done what I wrote?
Results ?

[EgonHugeist]

Sorry guys, wasn't at home.

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

5min work... Confirmed?

Michael

[markus]

It does work better;)

[EgonHugeist]

markus,

??? What you mean here?

[markus]

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

With rev 1126 this problem is gone

[cpalx]

Thanks.