Subject Re: [IBO] Live queries
Author Lele Gaifax
>>>>> On Fri, 26 Jan 2001 08:22:50 +1100, Helen Borrie <helebor@...> said:

HB> At 09:35 PM 25-01-01 +0100, you wrote:
>> >>>>> 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.

HB> Did you set RequestLive to True?

Yes, but it wasn't enough. By using bogus InsertSQL, EditSQL and
DeleteSQL as Jason suggested I was finally able to alter the
table. Thanx a lot.

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.