What version of IBO do you have?

If I recall, I needed to make it return true when the OnUpdateRecord event
was assigned. Prior to this fix the workaround was to put a bogus EditSQL,
etc. property value.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Lele Gaifax" <lele@...>
To: <IBObjects@egroups.com>
Sent: Thursday, January 25, 2001 1:35 PM
Subject: Re: [IBO] Live queries


> >>>>> 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.
>
>
>
>