Subject | GeneratorLinks with TClientDataSet |
---|---|
Author | Sandy |
Post date | 2005-06-15T10:51:49Z |
Hi,
I'm trying to build a multi-tier application which uses a firebird database
system, with a TIBOQuery component on the middle tier, and a TClientDataSet
component on the client. My TIBOQuery component is linked up to a table
which has a generator for the primary key, together with a BeforeInsert
trigger. If, in the client code, I call 'Insert' on the TClientDataSet I get
told that the primary key column needs a value - I've tried to add an entry
in the GeneratorLinks property of the TIBOQuery and have also selected
bsAfterInsert in the BufferSynchroFlags. It still doesn't work though.
Am I doing something stupid here? Is the TClientDataSet a bad choice for the
client?
Regards,
Sandy MacPherson
[Non-text portions of this message have been removed]
I'm trying to build a multi-tier application which uses a firebird database
system, with a TIBOQuery component on the middle tier, and a TClientDataSet
component on the client. My TIBOQuery component is linked up to a table
which has a generator for the primary key, together with a BeforeInsert
trigger. If, in the client code, I call 'Insert' on the TClientDataSet I get
told that the primary key column needs a value - I've tried to add an entry
in the GeneratorLinks property of the TIBOQuery and have also selected
bsAfterInsert in the BufferSynchroFlags. It still doesn't work though.
Am I doing something stupid here? Is the TClientDataSet a bad choice for the
client?
Regards,
Sandy MacPherson
[Non-text portions of this message have been removed]