I am using TOracleDataset with:
SELECT S.ROWID, S.* FROM STAMM S
The table contains 1 NCLOB field that is displayed in in TDBMemo.
As soon as we do
StammTable.Edit;
the text in the TDBMemo gets changed to "??".
When we save with
StammTable.post;
StammTable.session.commit;
it still shows "??".
Even when we change the record (next; previous;) we see "??".
Searching this forum, I found that for CLOBs the dataset needs to be re-opened.
Besides that was a thread that was posted many years ago ... I cannot imagine that this is the suggested way of working with (N)CLOB fields.
Indeed: when we close and re-open the dataset we do see the correct data again in the TDBMemo.
Of cause, that is not really an option when you do "table.edit".
What is the recommendation to handle NCLOB fields?