Subject Re: [IBO] InsertSQL
Author Lucas Franzen
Tilo Muetze schrieb:
> Jason and list,
> we want to insert, edit and delete a 3-way-joined query. We can put several
> statements in the UpdateSQL and DeleteSQL property without any problems, but
> if we try to put more then one statement in InsertSQL then preparing of the
> query fails. So what is the simplest way to insert in a join like this?


write a stored procedure that can handle the three updates and call the
procedure in the insert/update SQL-statement with:
EXECUTE PROCEDURE <sp_name> (paramlist)