Search found 6 matches

by pakis
27.09.2006, 10:10
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: PostgreSQL and serial part 2
Replies: 8
Views: 1529

Hello,
got SVN, but very busy next two weeks, so I will try to apply patch later.
by pakis
25.09.2006, 09:09
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: PostgreSQL and serial part 2
Replies: 8
Views: 1529

CVS Access

Hi, there is no patch, I can't access cvs at sourceforge, even I try everything as described in http://zeos.firmos.at/viewtopic.php?t=27 but something is not vorking. Plus hack I make was in opfficial 6.5.1 alpha source. So for now you have to apply patch to your own versionjavascript:emoticon(':(')...
by pakis
18.09.2006, 22:28
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: PostgreSQL and serial part 2
Replies: 8
Views: 1529

Hello, here is the ugly hack I made in Zeos 6.5.1 -alpha source in ZDbcGenericResolver.pas file. Pavel function TZGenericCachedResolver.FormCalculateStatement( Columns: TObjectList): string; var I: Integer; Current: TZResolverParameter; begin Result := ''; if Columns.Count = 0 then Exit; for I := 0 ...
by pakis
18.09.2006, 07:19
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: PostgreSQL and serial part 2
Replies: 8
Views: 1529

PostgreSQL and serial part 2

Hello, I have folloving problem, when Zeos try to insert serial column into table it use SELECT nextval(id_seq) FROM TABLE but in postgres it should be just SELECT nextval(id_seq). First statement doesn't return any value if Table is empty. If TABLE have n records then it n times increase id_seq val...
by pakis
15.09.2006, 09:11
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Problem with serial type in PostgreSQL database
Replies: 2
Views: 755

Hi Mark, thanks for fast reply. What I do is simple INSERT (id_art ....) values (1, ...) from SQL editor. In program I don't use sql but simple Ztable conected with DBGrid, where I insert other values except id_art + ApplyUpdates.This work fine but only after I insert first record. Same things happe...
by pakis
15.09.2006, 07:32
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Problem with serial type in PostgreSQL database
Replies: 2
Views: 755

Problem with serial type in PostgreSQL database

Hello, I have folloving problem: using Ztable + Delphi 7 + PostgreSQL 8.1.3 table have id_art serial type, reguired is false, it is not a key when I try to post to table receive message cannot insert null in id_art But if I insert first record by hand (INSERT ....), after than everithing work fine a...