🚀 go-pugleaf

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 ?

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();
  //
-----------------------






"Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca> wrote in message 
news:470d3e3b@newsgroups.borland.com...
> Alain wrote:
>>
>> These properties are not triggered when inserting in the table
>>
>> either in the Stored procedure component property nor in a table
>> property related to the table
>
> I assume you are talking about events of a dataset component like TIBQuery 
> or TQuery or IBDataset or TTable?
>
> These events fire on these components when you use the component's Insert 
> function. If you are directly executing an SQL Insert statement (e.g. with 
> an TIBDataset) then these events do not fire.
>
> -- 
> Wayne Niddery - Winwright, Inc (www.winwright.ca)
> "The only reason some people get lost in thought is because it's
> unfamiliar territory." - Paul Fix
>