bind additional column data using JC_INSERT?

ChemAxon 60ee1f1328

27-06-2005 13:10:37

Hello,





I would like to know if/how I can use the JC_INSERT cartridge function to bind my runtime data similar to "uh.setValueForAdditionalColumn(1, name);" or jcman command line connect "SUPPLIER_NO=ID"





Thanks again,


Daniel.

ChemAxon aa7c50abf8

27-06-2005 13:39:20

Daniel,





You cannot directly do this with JC_INSERT. You have to first insert the structure into the table using jc_insert, and then you have to execute a separate INSERT to enter values into the user defined columns using the cd_id(s) returned by jc_insert.





Peter

ChemAxon 60ee1f1328

27-06-2005 14:09:03

Hi Peter,





Thanks for you answer and now I realise I have asked that question before and have a bit of code about that will do just that.





Thanks,


Daniel.