error occurred when manage catalog

Hi,

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 5.6.0.3

Is there a solution for this?

Thanks in advance.

Hi, it seems that you have defined the field length to be only 10 characters. Whilst the CAS number format is for 10 digits (see http://en.wikipedia.org/wiki/CAS_registry_number#Format) there are also two hypens in it so you need at least 12 characters.

The solution is either:

1. delete the field and re-create it with a column length of 12

2. edit the column length property of the existing field and increase it to 12

Both of these operations can be done in the schema editor:
http://www.chemaxon.com/instantjchem/ijc_latest/docs/user/help/htmlfiles/editing_database/schema_editor.html

Tim

hi tdudgeon,

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?

Tim

Tim

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.

Tim