Hello,
got SVN, but very busy next two weeks, so I will try to apply patch later.
Search found 6 matches
- 27.09.2006, 10:10
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: PostgreSQL and serial part 2
- Replies: 8
- Views: 1585
- 25.09.2006, 09:09
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: PostgreSQL and serial part 2
- Replies: 8
- Views: 1585
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(':(')...
- 18.09.2006, 22:28
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: PostgreSQL and serial part 2
- Replies: 8
- Views: 1585
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 ...
- 18.09.2006, 07:19
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: PostgreSQL and serial part 2
- Replies: 8
- Views: 1585
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...
- 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: 776
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...
- 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: 776
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...