Zeoslib Portal

Hi, i've got table structure like this: CREATE TABLE customers ( id serial, type_id integer, name text NOT NULL DEFAULT ''::text, street text, zip text, city text, phone text, email text, contact_person text, www text, last_contact date, next_contact date, status integer NOT NULL DEFAULT 0, CONSTRAI...

Michael,
You can download 30 day trial of RadStudio XE3:
http://www.embarcadero.com/products/rad ... /downloads

Best regards,
Marek

Hi, I've encountered problem with PrepareSQL property of ZConnection. My query is like this: select *,null as typ_upustu_tmp, null as czas_trwania_tmp,null as thumb from (SELECT * from data.klienci )q WHERE (imie ~* 'ed') AND (usr_status >= 0) but when PrepareSQL is set to true PostgreSQL receives q...

Michael,
thank You very much.
Ps. Congratulations on becoming a dad

merovingio,
could You at least give us list of files that You changed?
Please don't expect us to go through all zeos source to find Your few lines.

You know how to make a svn diff file?
It will be better to compare changes.

and you could attach this file here. Posting email in open forum is not best idea - spam bots never sleep;)

Besides - if you made changes in zeos source then it's most probably some delphi issues
not c++ builder

I work under C++ Builder 2010.
And no problems with compiling either:)

There were some issues with packages for cbuilder12, but it was resolved some time ago.
merovingio, maybe post error messages you got, and we'll try to help You.

EgonHugeist wrote:markus,

"sometimes" is strange. But i will check this, Marek.

Michael

I've been testing my app last week with rev. 1346 trying to get data badly encoded.
But it never happened:)

Thanks a lot Michael:)

i know it's strange - i've been trying to get solid reproduction pattern since yesterday - with no effect.

Hi all, i've encountered problem with Zeos encoding utf8 strings. http://img703.imageshack.us/img703/3121/bugau.png two visible rows are added with the same exe, more even in the same session. both should be "ąę" values, but first one have broken encoding. What is most surprising, i cannot...

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

With rev 1126 this problem is gone

It does work better;)

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/postgresql/manager This bug do exist - simple test case: Put ZComponent and ZQuery on a form. Configure Your pgsql connection. Enter Query text just like c...

To add more - i think its almost impossible to refresh all updated records (but only them) for one big reason: trigger functions - they can change almost everything in DB.

Hi all:)

I've been playing with ZPgEventAlerter to incorporate mrLion idea.

With my changes we will be able to create a tree of EventAlerters with only one processor handling notifications from DB.

But it would be nice if some Pascal specialist look at it and check potential bugs/errors etc.

Marek

mrLion , You're right about flaws in design of notifications, but Your example (two windows with listeners) is error prone itself. According to libpq documentation: The function PQnotifies returns the next notification from a list of unhandled notification messages received from the server. It retu...