Subject Re: [IBO] InsertSQL question
Author Helen Borrie (TeamIBO)
At 03:04 PM 05-03-02 +1100, Eric Handbury wrote:
> I have a dataset where the user will use the TIB_UpdateBar to
>edit/insert/delete records.
> The edit/delete functions will be standard, but I want the Insert to do
>the following steps:
> 1) Aborts the Insert
> 2) Calls a SP which gets values from another table, and inserts a new
>record into the target dataset.
> 3) Sets the new record into Edit-mode upon the SP returning.

It simply is NOT as complicated as you describe. If you include an
InsertSQL statement in the dataset properties, it simply *replaces* the
standard Insert processing. There is no "other insert" which has to be
"aborted". Just call the SP in your InsertSQL, and the standard insert
processing will be overridden.

And, just as with the standard processing, when the Insert has been done,
the dataset will do what it knows it has to do after any DML is
committed. Your code does not have to do anything to get it back into Edit

Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at