Zeoslib Portal

Hello, all first of all - great work! I think people will find the components useful for their tasks. There are some notices I'd like to share with you. First of all the bug http://zeosbugs.firmos.at/view.php?id=232#bugnotes. The patch provided by papelhigienico fixes it. I looked through the source...

Hello,

the change applied may be ok for FPC 2.5, but for FPC 2.4 it raises exception when compiling. Attaching patch that should fix the problem.

gmb,

I don't know what about 6.5.1, but in zeos 7 the management of sequence values is done by handling default value. I just don't insert or update the field with sequence - that is done inside the zeos...

I think your example would run fine with zeos 7.

gmb , Well, the script can be very simple update pg_attrdef set adsrc = pg_get_expr(def.adbin, def.adrelid); Anyway - I have never done so and because only God knows who uses adsrc and for what reasons I would discourage you from updating it (without serious testing at least). The introduction of T...

gmb , Strange that is only occurring now. You are truly right.. Have you been doing backup/restore successfully in past? I can't say since when backup/restore cuts the schema off, but I faced the problem more than 2 years ago. Will changing the ZConnection.Protocol have any impact? Changing the pro...

Hello, gmb , If I remember correctly, there was a problem with serial collumns once.. In ZDbcPostgreSqlMetadata the expresion pg_get_expr(def.adbin, def.adrelid) should be used instead of adsrc when finding default values for fields. The problem is pg_restore does not restore adsrc correctly. It los...

Hello aktivo in short - you cant detect the connection loss without trying. Executing queries after connection is lost used to lead to Access violation exceptions. In version7 this was fixed. There are 2 ways to ensure connection: 1) pinging server before every query. If ping does not succeed - disc...

Hello, vfclists , I've been using zeos + postgres for several years. I use ZUpdateSQL too, but I have never observed the behaviour you describe... I would suggest using TZSQLMonitor and see what statements are executed. Maybe you issue nextval('seq_name') manualy? Also check if increment of the sequ...

Hello garynorton , I've investigated the ExecuteDirect implementation for postgres and it seems to me the behavior of ExecuteDirect and TZQuery.Open should be the same. I guess you encounter the old problem of lost connection that led to Access violation usualy. It was resolved in v7 of Zeos (SVN Re...

Morenz,

I'm not sure. Maybe if you could provide a test case (db and source) I could test it on my machine and find out what is wrong.

Anyway that would not be sooner then the day after tomorrow, as I have alot of work these days.

Morenz , I don't know what svn client you use, but with Qsvn I select "Show Log" from pop up menu on Zeos project . By the way - the beauty of TZSQLMonitor is that you don't have to "put down some lines" in code... Just drop the component, specify the filename and activate it. N...

akli_agha,

SELECT sum(price) FROM payments
group by case when sale_date > '2010.01.01' then 1 else 2 end

At least this works for postgresql.

Good luck.

Hello, Morenz , I've created the table you provided on server v. 8.4.3, entered some data, edited the statomir column without problems. Do you use downloaded zeos version (snapshot) or do you get it from svn repository? Mine is from repository... (revision 803). Maybe there something in DB settings?...

Morenz,

could you provide the SQL creation srcipt of the table you try to edit? If you are using pgAdmin - just copy script from SQL pane positioned in the right of the main window.

JD,

from my experience with Zeos + Postgres I'll advice you not to use single connection object in several threads. I don't know what database management system are you working on, but libpq does not support this (I found that out the hard way). So check your DB provider

Good luck.