Zeoslib Portal

Hello mdaems , sorry for a long delay. I would be glad to produce such a patch, but I wanted to consult You a bit before coding: 1) by saying ZQuery property did you mean new property of a component or a new parameter in TZQuery.Properties? 2) what name would you suggest for it? BusyPointerWhenScrol...

Hello hzmsky , are you sure you have all the dll's used by the libpq ? Zeos uses this library to connect to postgresql DB. If you are not sure what files are needed just open pgAdmin directory (I'm sure you have it if you work with PostgreSQL) or from the Postgresql subdirectory named "bin"...

Hello, vajtsz , I'm not sure what zeos is doing when you "click on a menupoint", but I can share my experience here. I've noticed that if I do a TZQuery scan (read every row in a cycle) my program performance is poor. Also like You I observed, that SQLHourGlass := False eliminates the prob...

hello papelhigienico,

but float(32) bit should have at least 7 digit precision. This is more than needed for the example. Please explain in more detail what goes wrong here please.

Thank you in advance

hello

try deleting field and then adding it manually in the field list. When adding manually you can specify the field type. There is no way to convert a field from one type to another without recreating it. I'm not sure it will help (or work at all) but please experiment

Good luck!

Would you please try using BCD Fields instead Float fields?

the problem is due to the float representation 1.95 is in fact stored as 1.94999... The problem is that when writing it to DB it does not get rounded but truncated... I didn't notice that behavior on postgresql I'm working with so my guess is the problem is in interbase (firebird) part of zeos. Woul...

hello,

are you sure you get the 1.95 -> 1.9444 ?? not 1.95 -> 1.9499 by chance?

Hello, I must have misunderstood your intentions. If you say nothing will brake - its good to hear. Please tell when can I checkout the testing branch to test. Tried inserting to tables with bigserials - everything seems to work ok with my version of Zeos. Adding test program with DB backup file (db...

Hello, all in my company we work with Postgresql and Zeos7. We use serial attributes as keys for many tables and we have a lot of forms with TZQuery components and id fields have AutoGenerateValue = arNone. This works fine for us - sequence is incremented by 1. If I understand you correctly after yo...

Hello tbonejo,

have you installed libpq in your mac ?

If so, please make symbolic link to libpq in /usr/lib/ like this:
sudo ln -s /usr/lib/libpq.5.dynlib /usr/lib/libpq.so

it's described there:
http://lists.freepascal.org/lists/fpc-p ... 12067.html

Good luck!

cmatrix , sorry, I'm not a MS SQL user, though I use Zeos v7 with Postgresql and Delphi 2006 without problems. I use it from svn so please try to get it from there, because package in sourceforge is almost 2 years old. You have checked the dataset if it is readonly, but the fields can be readonly t...

cmatrix , by saying "databound controls don't seem to work" you mean they doesn't show data, they can not edit data or something else? What database do you use? What language (delphi, lazarus) and it's version? Where did you get Zeos7 from? Downloaded build package or from svn ? Please pr...

Hello, jeremicm,

I'm going to try XE2 these days, so I'll look into your problem too. Right now I have no ideas what else could be wrong.

have you set codepage=utf8 in properties of tzconnection ?

[update]
by writing "latest zeos" you meen 6.6.6 (stable) or 7.0 (beta)?