Zeoslib Portal

Thanks Jan , I'll take a look at the svn repo. Will post here again if I need any more info.

Regards

Hi For reasons one of our projects is still stuck on Delphi6 - we're using the latest compatible ZEOSLIB (6.6_stable). We're increasingly running into problems where this is raised: >> Input parameter count is less then expected. Further investigation showed that this is caused by the question marks...

Hi all, I hope these is a simple solution. Online searches was not able to assist me in solving this. Using Delphi XE5, Zeos 7.1.4 with PostgreSQL. We are loading a library of scripts (compiled as resources) at runtime and executing the SQL. Recently we started to encounter syntax errors and after s...

Apologies, I know there are many posts out there on this subject, but tried a lot of the suggestions and still cannot get this right. If someone can point me in the right direction, I'll appreciate it a lot. I'm using Delphi6, ZEOS v 6.6.6, PostgreSQL 9.2 (DB encoding = UTF8) Posting a string value ...

Thanks for the response, Wild_Pointer (and sorry for my late reply) I've read some articles about AutoCommit, but cannot quite understand what effect it will have on my code. As far as I understand, setting this to TRUE will mean that each statement is committed automatically, which negates my goal ...

Hi there Using Zeos 6.6.6-stable with Delphi6 on Postgres 8.3 I'm having difficulty implementing transactions in my application in the way that I feel will be most practical. My app is running lengthy DB processes which I'd like to put in transactions; I've implemented it like this: ExecSQL( 'begin;...

THanks mdaems,
I'll have a look at ver 6.6 then.
Regards

7.0.0-alpha is the first experimental release which should make zeoslib usable on Delphi 2009 and Delphi 2010. Support for Delphi versions older than Delphi 7 has been removed.

Guess this means I'm stuck with pre ver 7 versions as I'm using delphi6

Wild_Pointer
I'll check it out,
Thanks again for your help

Wild_Pointer Thanks , I'll probably stick with the 3rd option for now. The introduction of TZSequence in versions after 6.1.5, however, implies a major overhaul of my code - something I just do not have the time for now I have never used TZSequence yet Sorry if this is a stupid question, but how do...

1) update zeos components. (that would be the right thing to do). We are now using zeos 7 in our system without problems. As you say this will be the most "correct" way of solving the problem and probably something I'll have to take a look at in the long run. The introduction of TZSequenc...

THanks for the replies. It loses the schema Hi Wild_Pointer, what you are saying here sounds exactly like my problem. Strange that is only occurring now. Maybe related to changes in pg_dump/pg_restore? Will changing the ZConnection.Protocol have any impact? Currently I'm using postgresql-7.3 (for no...

Hi all, Using Delphi6 & Postgres with zeos 6.1.5 - and have not had any problems like this before. My app is very dependant of schemas in the DB and also use serials columns for PK's: CREATE TABLE sch1.tab1( tabid SERIAL PRIMARY KEY, tabdesc TEXT ); which implies: CREATE SEQUENCE sch1.tab1_tabid...

Seems all that was necessary was a restart of the server :(
...wish I hadn't spend the whole day on this

Hi all I'm getting the following message when trying to connect to Postgres server: [quote]SQL Error: invalid encoding name in PGCLIENTENCODING: WIN1252[/quote] Delphi 6 application with Zeos 6.1.5 on Windows 7 (64x), PostgreSQL 8.3 I tried re-installing PG using different encoding, but had no luck....