Subject Re: [IBO] BUG: not "live" query can't be inserted
Author pi3k14
--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@...> wrote:
>
> At 04:08 PM 22/08/2006, you wrote:
> >Hi all,
> >There have been a change in TIBODataset.GetCanModify that requires
a
> >dataset to either have set the property RequestLive or
CachedUpdates
> >to allow inserts.
> >

There is no such thing as a "live
> dataset" in SQL. Period.
I don't dispute that, never has.

>
> >The workaround is to set the RequestLive property.
>
> It's not a workaround. It's what IBO requires (along with clean
> KeyLinks) to know what statement it has to construct as the
InsertSQL
> property.

If that is a requirement, then it is a new one for this release.
Because it wasn't necessary before. And if so, the description for
TIB_Query::RequestLive at best is misleading. "This property is used
in order to make a SELECT statement updatable and deletable."


frode