Subject Re: [IBO] TBlobField in IBOQuery with CachedUpdates=True
Author earnesttse
--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@...> wrote:
>
> At 12:01 AM 27/09/2007, Earnest wrote:
> >Hello,
> >
> >I have a problem with IBOQuery's CachedUpdates.
> >
> >I found that when IBOQuery's CachedUpdates is set to true, the Blob
> >field will be emptied if I try to insert a new record.
>
> Could you explain what you mean by "emptied"? A blob field on a
new
> record will be null...

Sorry for my poor English.

When I try to insert a new record, the value of BLOB field of last
record will be deleted. There is value of BLOB field in last record
only.

If I insert one record only and post it by calling ApplyUpdates &
CommitUpdates before to insert a new record. This record's BLOB value
will be saved. If I try to insert the second record, the BLOB field
value of first record will be null.

> >If I set CachedUpdates to false, everything is OK.
>
> What is "OK"? Are you talking about editing in a DBGrid?

Yes, I edit records in wwDBGrid (InfoPower's DBGrid), but I call
another form to edit the value of BLOB field.

If I set CachedUpdates to false, all records' BLOB value will be
saved.

Helen, thanks for your reply and help!

Regards,
Earnest