Devart Forums

UniConnection:
Direct := False;

Client + Server(UniDAC, Midas, UpWhereKey, Resovletodataset is false) + Oracle 11g

Problem:
Submitted data set contains multiple update field,Non-BLOB fields are updated, the BLOB field has not been updated,

Orace trance can be tracked to update BLOB field of the assignment statement, but written to the BLOB field is null/''，

If do not the Midas submit data, update and insert BLOB field is normal

I did wrong？？？ tks

clientdataset submitted delta is normal,

hello,

For correct insertion of BLOB data, you should set the TemporaryLobUpdate option to False

UniQuery1.SpecificOptions.Values['TemporaryLobUpdate']:= 'false';

Since you have set the ResolveToDataSet property to False, a query for data insert is formed in ClientDataset and uses EMPTY_BLOB() for BLOB data insert, and when the TemporaryLobUpdate option is enabled - the EMPTY_BLOB is created once more, and an "empty" BLOB is transferred to a server.

Thank you very much, the problem has been solved, that is for this reason

Hello,

Glad to see that the problem was solved. If you have any other questions, feel free to contact us.