🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.multi-tier
Article #1532

Re: TClientDataSet and Oracle Triggers.

#1532
From: 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
Technical Details
Message-ID: <37EACBE9.A7D397E2@bcbdev.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <7scsa3$9i74@forums.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,383d69fbf0db394
X-Google-Attributes: gidfcd2b,public
From: "Harold Howe [TeamB]" <hhowe@bcbdev.com>
Subject: Re: TClientDataSet and Oracle Triggers.
Date: 1999/09/23
Message-ID: <37EACBE9.A7D397E2@bcbdev.com>
X-Deja-AN: 528867314
Content-Transfer-Encoding: 7bit
References: <7scsa3$9i74@forums.borland.com>
Organization: Another Netscape Collabra Server User
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.multi-tier