I've got some TMS DB-aware components, including TDBAdvMemo, that are tied to a bunch of DB fields in TOracleDataSet components.

Some of these memos are tied to varchar2 fields, and one is tied to a CLOB field.

If I set the dataset into Edit mode, I can edit content in all of the controls except the one tied to a CLOB gets cleared instead of being saved.

I'm not getting an kind of error message.

Am I doing something wrong? A setting I may be overlooking?

Can you show me the SQL text of the TOracleDataSet?

select ds.rowid, ds.* from table1_datasets ds

There are a dozen fields in this table. When I put the dataset into Edit mode, they all save fine except the CLOB that was just added. Why is the CLOB not being saved?

This is really strange. I have a pre-process step that initializes a bunch of fields in the tables. I set this CLOB field to show a line of text as the first line.

It shows up in every record when I'm scrolling through the table, as expected.

But again, when I go into Edit mode and then set theMemo.Lines.Text := 'some more text', it shows up initially.

But when I do the Post, it's reverted to the original field contents.

I'm really puzzled.

This is indeed puzzling. Can you check if it works correctly if you replace the TDBAdvMemo with a TDBMemo?

Hmmm ... it works fine with TDBMemo.

It also works with a TcxDBMemo