Search found 2 matches

by enix
03.02.2012, 00:11
Forum: PostgreSQL
Topic: Postgres + doCalcDefaults + Bigserial Column = 2 on 2 seq.!
Replies: 27
Views: 8277

I know exactly this problem. First - You are using ZEOS 6.xxx, it's behavior is that after insert record default value is obtained from server, after post record default value is obtained from server again. Thats why value of field increases by 2. I suggest to install ZEOS 7 - all works fine, defaul...
by enix
02.02.2012, 23:03
Forum: PostgreSQL
Topic: Server Side DataChange
Replies: 6
Views: 2159

Yes. Use ZUpdateSQL assigned to ZQuery as UpdateObject.
Set ZUpdateSQL.RefreshSQL statetment that select current reccord, for example:
SELECT * FROM table WHERE PrimaryKeyID=:PrimaryKeyID
After post reccord You can refresh it by: ZQuery1.RefreshCurrentRow(true)

reg. Enix