🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.interbase.sql
Article #579

Re: AfterInsert and BeforeInsert property

#579
From: Karol Bieniaszewski
Date: Thu, 11 Oct 2007 14:21
37 lines
2054 bytes
U�ytkownik "Alain" <alainbastien@gmail.com> napisa� w wiadomo�ci 
news:470de1fb@newsgroups.borland.com...
>I am using Stored Procedure components
>
> The Stored procedure inserts row in a table
>
> it is  Local Interbase 6 Windows XP
>
> My application process incoming SMS and upon reception following
> certain rules contained in the message it inserts in a table using the 
> Stored Procedure
>
> Now where do I use AfterInsert ?

for what you need AfterInsert ???


>
> The component Stored Procedure does have After and Before insert events 
> handler
>
> But are not triggered when
>
> this
> -------------------------
> // store in database incoming messages
>  Add_message->Prepare();
>  Add_message->Params->Items[0]->AsString=aSms->Phone;
>  Add_message->Params->Items[1]->AsDateTime=aSms->DateTime;
>  Add_message->Params->Items[2]->AsString=aSms->Text;
>  Add_message->ExecProc();
here you are now aftrer insert
- i do not understand you


Karol Bieniaszewski 
Technical Details
Message-ID: <470e301a@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!proxad.net!feeder1-2.proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail
References: <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
From: "Karol Bieniaszewski" <liviuslivius@poczta.onet.pl>
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 16:21:47 +0200
Lines: 39
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: 195.205.151.58
Message-ID: <470e301a@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1192112154 195.205.151.58 (11 Oct 2007 07:15:54 -0700)
Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!proxad.net!feeder1-2.proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail