<hinfun@...> wrote in message news:9qk650+sude@......

> I am trying to use a similar features from MS whereby SP are being
> use for Data Processing.
>
> I have created a before insert trigger to generate a unique number
> treated as the session number for Table A.
> After numerous processing on Table B & C, the results were inserted
> into Table A. Table A later are being manupulated before inserted
> into Table D.
>
> Since IB doesn't support Commit statement inside SP, The update
> process from Table A to D cannot be seen.

The changes will be seen if they all happen in the same transaction (from
the client, that is).


--
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."