Article View: borland.public.interbase.sql
Article #582Re: AfterInsert and BeforeInsert property
From: Wayne Niddery [TeamB]
Date: Thu, 11 Oct 2007 16:09
Date: Thu, 11 Oct 2007 16:09
22 lines
1949 bytes
1949 bytes
Alain wrote: > I am using Stored Procedure components > > The Stored procedure inserts row in a table Ok, the stored proc component descends from TDataset, which is what has the Before/AfterInsert (and other) events. But the dataset cannot know what is going on inside a stored procedure, there is no connection whatsoever. It is not that the dataset fails to do this, it is that there is no possible way to do it. If the stored proc returns without error, then that is, by definition, after insert (and after whatever else it is doing there). If you really must know immediately upon the stored proc performing an individual statement, then you need to look at raising events from the database that you can catch in your application. -- Wayne Niddery - Winwright, Inc (www.winwright.ca) "The only reason some people get lost in thought is because it's unfamiliar territory." - Paul Fix
Technical Details
Message-ID:
<470e4abe$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<470cfae8@newsgroups.borland.com> <470d3e3b@newsgroups.borland.com> <470de1fb@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,5935be3261d799e7 X-Google-Attributes: gid114a0e,public,usenet X-Google-Language: ENGLISH,ASCII-7-bit Reply-To: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca> From: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca> Newsgroups: borland.public.interbase.sql References: <470cfae8@newsgroups.borland.com> <470d3e3b@newsgroups.borland.com> <470de1fb@newsgroups.borland.com> Subject: Re: AfterInsert and BeforeInsert property Date: Thu, 11 Oct 2007 12:09:33 -0400 Lines: 24 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.3138 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198 X-RFC2646: Format=Flowed; Response NNTP-Posting-Host: 69.17.170.228 Message-ID: <470e4abe$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1192118974 69.17.170.228 (11 Oct 2007 09:09:34 -0700) X-Authenticated-User: wniddery Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail