Subject Re: InsertSQL question
Author ehandbury
--- 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
> data during the user input phase of the 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
> components for your main project. This cursor comp. can call (via
its SQL
> property) either a selectable stored procedure or a SELECTed
> according to your requirements. Make quite certain that you pass

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

Thanks. Eric.