Devart Forums

I have a problem with DeferredBlobRead property of TUniQuery.
a) I open Firebird table via TUniQuery.
TUniQuery has DeferredBlobRead set to True.
Table contains some text blob fields, which are not displayed on my form.
b) I change value of one field and save record.
All blob fields data are lost!
It appeared probably in version 6.2.7 or 6.2.6.
It is a huge problem for us, because we use DeferredBlobRead on some hundreds forms and many our customers are losing their import information! How to resolve the problem?

Unfortunately, we can't reproduce the issue. To investigate this behavior of UniDAC, please send to viktorv*devart*com a small sample to demonstrate the issue, including a script for creation and filling in the test database object.

Hi I have the same problem. All blob fields data will be lost!

The settings:

FetchAll := false
CacheBlobs := false
DeferredBlobRead := true

In my application the problem appears in one case: when the record is re-read (method Refresh is called).
I found all places, where Refresh is called, and I directly read Blob fields there.
For example I wrote something like this:

var
S: string;
begin
CUSTOMER.Refresh;
S := CUSTOMER['NOTES'];
end;

This code causes NOTES blob data to be loaded and information is not lost after post.
Of course the best solution would be removing the error by Devart, but I hope this will help for now.

Thank you for the information. We have reproduced the problem and investigation is in progress. We will inform you when we have any results.