Subject Re: [IBO] TBlobField in IBOQuery with CachedUpdates=True
Author earnesttse
--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@...> wrote:
>
> At 12:55 PM 27/09/2007, you wrote:
> What versions of
>
> 1. IBO?
IBO 4.7.16 in Delphi 6, IBO 4.8.7 in Delphi 2007

> 2. Delphi?
Delphi 6 & Delphi 2007

> 3. Infopower?
Infopower 4000.0.6 in Delphi 6, Infopower 5.0.1.6

>
> The change of dataset state from dsEdit to dsInsert, or making a
new
> call to Insert, is meant to post the outstanding changes *to the
> dataset*. When CachedUpdates is true, this Post operation does not
> post the changes to the database, but updates the cache buffer.
Only
> ApplyUpdates posts the cached changes from the cache buffer to the
database.

Yes, I understand. I guess that IBO clears the BLOB's value when call
insert command. I tried to call post command before moving to a new
record, but it doesn't work. This problem affects BLOB field only.


> I wonder whether your workflow for catching the contents of your
> BLOB-editing form actually works with cached updates.
>
> 4. Could you please show how you update the BLOB field from this
form?

When user insert a new or edit a old record in DBGrid, I allow user
to press a function key to call a form which has a DBMemo. The
datasource of DBMemo is set to AutoEdit=True.

I tried call post before the form.show and after the form.close, but
it doesn't work too.


Thanks for your reply and help!

Regards,
Earnest