Subject | Re: [IBO] BUG: not "live" query can't be inserted |
---|---|
Author | pi3k14 |
Post date | 2006-08-24T12:42:54Z |
--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@...> wrote:
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.
>a
> 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
> >dataset to either have set the property RequestLive orCachedUpdates
> >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.