A customer asked me to upgrade a legacy applciation from Oracle 7.x support using the BDE to Oracle 9i support using DOA (latest version). In their updated schema, they have a TIMESTAMP field in all tables.

My challenge is that I have an updatable dataset (yes, I include ROWID). Table opens and displays, but when I attempt to edit the record I get a nasty Oracle Error - "ORA-01406: fetched column was truncated".

I creates a test table that does not include the the TIMESTAMP field and my edits work.

In the problem table I do not inlcude the TIMESTAMP field in the SQL string, but I get the problem anyway (not when I OPEN the dataset, but when I switch to EDIT state).

Any help appreciated...