Data truncation inserting into an Oracle8.1.7 database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a TextBox control with a databings to a dataset.column name. The
MaxLength property is 2000 bytes.

When I enter data e.g. 1957 bytes and do a Update the screen remains
complete, but if I close that window and come back typically only 1000 bytes
are read and displayed.

Checking the database only 1000 bytes were written.

If I add the missing text and do another update, it will eventually get added.

Has any one else experienced this?

Thanks in advance for your help.

Gary
 
Do you use a DataAdpter? Try to reconfigure it, specially if you have
changed the max size of the db field.
 
Look in the generated code, you should be able to find where the
DataAdapter will be configurated.
Look for the generated Parameter of the text field for update/insert
commands and look at the dimension of the "varchar" (normally for text field
will be used varchar)
If the dimension is 1000, there is your problem.
 
Back
Top