RefreshRecord does not refresh LOB of the current record.

[planas]

Hello,

RefreshRecord does not refresh LOB of the current record.
We try to make the refresh in OnApplyRecord.
But if we tried to set the new clob value in the dataset we need to make an edit and a post of the dataset.
But if we edit the dataset DOA generate a new update statement at the next post.
We just need to refresh client memory with the new value.
We look in the DOA sources, so we found WorkBlobs. Is this attribute contain the lobs of the current record or
all the lobs of the dataset ?
How to implement this functionnality ?

JP

 

[Marco Kalter]

LOB's are indeed not refreshed by the RefreshRecord function. Making this modification is not so straightforward that I can send you an implementation. We hope to address this restriction in 4.0.

The most simple way to refresh a LOB is by refreshing the dataset.

------------------
Marco Kalter
Allround Automations

 

[planas]

Hello,

We need this functionnality now. So we decided to implement it in our component. We need to understand where you store lobs in memory.
Whitch private attribute contains lob pointer ?
Is it WorkBlobs ?

JP

 

[Marco Kalter]

Each record (TRecordData) in the result set has a LobList variable, which is a collection of TOracleBlob items, which contain the actual BLOB data.

I hope this helps.

------------------
Marco Kalter
Allround Automations