Customise the structure table cd_id

Hello,

I want to use this format "varchar2(20 bytes) like for example AB-00000001" for the cd_id instead of the incrementing integer, can you please give me some advices.

Thank you and kind regards,

Idris S.

Hi Idris,

CD_ID is an opaque identifier. (We even plan to deprecate the methods that allow client code to set CD_ID.) To store your own identifiers, I suggest to add a custom column to your JCB table.

For use with JChemManager, please see http://www.chemaxon.com/jchem/doc/admin/#create ("Specify the database table and the input file. The data fields in the file can be imported into the columns of the table. To support connecting the corresponding field names and column names, the program will detect field names in the file.")

For use with JChem API: UpdateHandler,.createStructureTable, StructureTableOptions.extraColumnDefinitions, UpdateHandler.setValueForAdditionalColumn .

Peter

http://www.chemaxon.com/instantjchem/ijc_latest/docs/admin/tips/triggers/index.html