TClientDataSet and Oracle Triggers.

Thread View: borland.public.cppbuilder.database.multi-tier

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Charles PAULET Thu, 23 Sep 1999 00:00

#1478

Author: Charles PAULET
Date: Thu, 23 Sep 1999 00:00

10 lines
757 bytes

Hi,

I'm using Oracle 7.3 and Builder 4 (BDE 5.1).
I have a trigger to simulate a NumberAuto. Before each insertion, the
trigger search the biggest field value and increment it.

With a TTable, it works fine, but with a ClientDataSet, the trigger is never
called. What's wrong with CDS component ?

Charlie

Re: TClientDataSet and Oracle Triggers.

#1532

Author: Harold Howe [TeamB]
Date: Thu, 23 Sep 1999 00:00

14 lines
1070 bytes

Charles PAULET wrote:

> With a TTable, it works fine, but with a ClientDataSet, the trigger is never
> called. What's wrong with CDS component ?

Are you calling ApplyUpdates? The Post method of TClientDataSet only
posts the record to the in-memory cache. You need to call ApplyUpdates
to send your changes to the database.

If you are calling ApplyUpdates, you might want to run the SQL monitor
to investigate the SQL code that was generated by the VCL.

Harold Howe [TeamB]
http://www.bcbdev.com

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads