Subject Re: [ib-support] Stored Procedure Processing
Author Martijn Tonies
<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

Upscene Productions

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