When I am trying to enter CAS number 956034-11-4, the popup shows ''A truncation error was encountered trying to shrink VARCHAR 956034-11-4 to length 10.
The free instant jchem version is 18.104.22.168
Is there a solution for this?
Thanks in advance.
Thanks for you reply. really appreciate it. I tried to change the column length, but I found the table showing the column length is 10 and I can not change it. Do I have to have license key to do this operation?
You should be able to type a new value into the Length field. For a Derby database that you are using you can only increase the length, not decrease it, but that's what you are wanting to do. Is the Length box not editatable for you?
Thanks again. I still can not found a way to change the column length. I can not edit that column.
It looks like you do not have any modify rights for the database (the add field icons are disabled).
Have you got security set up or something else that might be preventing you modifying the database in this way? If you do have security then you need to enter as singel user mode to make these sorts of changes.