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,
> >we are upgrading our app to use the latest IB_Objects version, and
> >stumbled over this problem.
> >
> >There have been a change in TIBODataset.GetCanModify that requires
a
> >dataset to either have set the property RequestLive or
CachedUpdates
> >to allow inserts.
> >
> >This conflicts with the following statement in the help description
> >for the TIB_Query.RequestLive property "Even if a dataset is not
> >"live" it can still be inserted into because in SQL there is no
> >concept of a INSERT INTO CURSOR."
>
> No, it doesn't conflict. That's just a statement of the facts, as
> was, as is and ever shall be. There is no such thing as a "live
> dataset" in SQL. Period.

???
Here is the new "offending" lines in TIBODataset.GetCanModify

if not RequestLive and
not (CachedUpdates and (Assigned(OnUpdateRecord) or
Assigned(UpdateObject))) then
Result := False

last comment date 07-Jan-2006 in IBODataset.pas
the version that work (that we used earlier) has last comment date 08-
Nov-2003
don't know what versions that corresponds to

So, if I don't set RequestLive I ain't allowed to insert new records.
Period.