Default Value for a Text Area field with spell/calc
529817Jan 23 2008 — edited Jan 23 2008Hi All,
I have a field (FIELD B) as above linked to a database CLOB column. I am defaulting the field to another field (FIELD A) on a different page in the application which is also linked to a database CLOB column.
While testing with less thna 95 characters, it all seems to be working fine; FIELD B was getting whatever was in FIELD A simply because FIELD B's default value is FIELD A.
Testing now with FIELD A having more than 100 characters, FIELD B only gets the first 95. When the page with B is submitted, the row cannot be processed because the rest of the characters from A seem to go into the other fields on B's page, and hence inconsistent data types errors are generated by the DB. It is like a spill over occurs from the text area that is "chopped off" from B into other fields on the page.
Should I be using some CLOB function and a process in Apex to copy the value of Field A as a CLOB to field B?
Field A and B's widths are 80, Max width is 32000 and height is 4.
I am running Apex 3.01 against 10gR2 on Windows platforms.