--- In IBObjects@y..., "Helen Borrie (TeamIBO)" <helebor@d...> wrote:

>
> Drop a TIB_Cursor into your datamodule, keeping it within the same
> transaction as your main dataset. This is to ensure consistency of

the

> data during the user input phase of the task...you can

pessimistically lock

> the row, too, if necessary, by using a sel. SP that includes a

dummy update

> following the block that fetches the dataset...if consistency is

not an

> issue but concurrency is, you can close the cursor as soon as you

have its

> data.
>
> You can use this regardless of whether you are using the TIBO* or

TIB_*

> components for your main project. This cursor comp. can call (via

its SQL

> property) either a selectable stored procedure or a SELECTed

dataset,

> according to your requirements. Make quite certain that you pass

Helen,
BINGO! I called a SP in the AfterInsert and it worked perfectly.

Thanks. Eric.