Search found 7 matches

by tarnschaf
07.10.2012, 12:07
Forum: 6.6 - stable
Topic: Bug in ZSQLProcessor dtSetTerm
Replies: 4
Views: 1421

Bug in ZSQLProcessor dtSetTerm

Hi, I found a reason why people experience difficulties with scripts containing "SET TERM". The problem occurs when there are comments before the SET TERM statement. ZSQLProcessor includes the comment into the complete statement (variable SQL) and then checks if the statement starts with &...
by tarnschaf
01.10.2012, 12:39
Forum: PostgreSQL
Topic: How to avoid encoded blob parameters
Replies: 6
Views: 2328

Hi, I checked out the latest revision of the trunk. The exception occurs when Free/Destroying a TFrame component. It did not occur with ZEOS 6.6. However, I am not able to reproduce it in a smaller application. The exception is NOT occuring when I remove an (empty) groupbox from the frame. Thus, it ...
by tarnschaf
30.09.2012, 21:11
Forum: PostgreSQL
Topic: How to avoid encoded blob parameters
Replies: 6
Views: 2328

Hi again, I am experimenting with Zeos 7 to achieve better performance uploading those files. I checked out the trunk/ version from Sourceforge and installed it. Luckily, my application (on first sight) still works as before. Changing the upload method back to use a TZQuery again and setting the opt...
by tarnschaf
28.09.2012, 20:22
Forum: PostgreSQL
Topic: How to avoid encoded blob parameters
Replies: 6
Views: 2328

Hi EgonHugeist, I somehow aniticipated that YOU would reply. Thanks a lot! The app is using bytea fields and I will have to read into OID blobs. It appeared to me that with the activated options all blob transfers are behaving differently which I didn't want. Will get back to you as soon as I figure...
by tarnschaf
27.09.2012, 22:39
Forum: PostgreSQL
Topic: How to avoid encoded blob parameters
Replies: 6
Views: 2328

How to avoid encoded blob parameters

I think (hope) that I have a rather simple question for ZEOS experts: We defined a table for uploading files to a Postgres 8.3 database, currently still with Zeos 6.6.6 stable, protocol "postgresql-8". Definition of the table looks like this: CREATE TABLE files ( "ID" serial NOT ...
by tarnschaf
27.09.2012, 22:02
Forum: 6.6 - stable
Topic: Compatibility Zeoslib Delphi 2007 - Postgres 9
Replies: 2
Views: 946

Hi,

thanks for your information. I solved the problem by switching back to Postgres 8.3. However, as soon as Zeos7 is considered stable, I will give it another try!
by tarnschaf
18.06.2012, 23:14
Forum: 6.6 - stable
Topic: Compatibility Zeoslib Delphi 2007 - Postgres 9
Replies: 2
Views: 946

Compatibility Zeoslib Delphi 2007 - Postgres 9

Hi, this post is meant to be something between a bug report and an information which might save someone some time. We have a Delphi 2007 (pre-unicode) application which works fine with Zeoslib 6.6.6 and Postgres 8.3 (Debian). After upgrading to Postgres 9 (on a Windows box), numerous encoding proble...