>>>>> On Thu, 25 Jan 2001 12:53:50 -0700, "Jason Wharton" <jwharton@...> said:

JW> You need to supply the customized update handlers. IBO cannot
JW> take a stored procedure derived dataset and make it
JW> live. Either use the OnUpdateRecord event and plug the changes
JW> into separate TIB_DSQL statements with the updates in them or
JW> if they remain static, just plug them into the InsertSQL,
JW> EditSQL and DeleteSQL properties.

That's what I tried: the OnUpdateRecord is there but whenever I do
iboquery.Insert/Edit it raises the unchangeable exception.

>>>>> On Thu, 25 Jan 2001 20:50:49 +0100, Lucas Franzen <luc@...> said:

LF> Lele,

LF> take a TIB_Query (not must, but better than IBOQueries) and
LF> enter your update statement in the EditSQL property.

It isn't distillable as a single update stmt. It surely doable with a
SP, but I'd prefer by far using the existing datamodule, which knows
the details of the update. It gives me a .InsertOperation (x,y,w,z)
and so on. With IBX in CachedUpdates, it let me .Insert and .Edit
records, and at CommitChanges time the OnUpdateRecord gets called for
each touched record.

thanx&bye,
lele.
--
nickname: Lele Gaifax | Quando vivro' di quello che ho pensato ieri
real: Emanuele Gaifas | comincero' ad aver paura di chi mi copia.
email: lele@... | -- Fortunato Depero, 1929.