Claus Pedersen
Member³
I have a table with a CLOB column.
I right-click on the table in object browser and select Edit data.
I go to the bottom (empty) record (marked with an asterisk *) and press the small three-dot icon to edit the clob data. I type in some clob data in the large data editor (in my case XML) and press OK.
Now I go to the record above to check some data.
I go to the new record again to edit again on my clob data. Now it is gone - Bummer.
It might be a hint that something is wrong that saving clob data does not cause a new record to be created, like when entering e.g. a number or character column in an new record. In the latter case, a new record is created, i.e. the symbol for the edited line shifts to a pencil and the new line is now marked with an asterisk.
Please make sure that edited clob data is always saved in the table row or at least display a warning to the user if he in the risk of losing data when e.g. navigating between records.
I right-click on the table in object browser and select Edit data.
I go to the bottom (empty) record (marked with an asterisk *) and press the small three-dot icon to edit the clob data. I type in some clob data in the large data editor (in my case XML) and press OK.
Now I go to the record above to check some data.
I go to the new record again to edit again on my clob data. Now it is gone - Bummer.
It might be a hint that something is wrong that saving clob data does not cause a new record to be created, like when entering e.g. a number or character column in an new record. In the latter case, a new record is created, i.e. the symbol for the edited line shifts to a pencil and the new line is now marked with an asterisk.
Please make sure that edited clob data is always saved in the table row or at least display a warning to the user if he in the risk of losing data when e.g. navigating between records.
