Who can tell "prop_value_ext null" this wrong

Hello everybody.





CREATE TABLE JChemProperties(


prop_name varchar(200) NOT NULL PRIMARY KEY,


prop_value varchar(200), prop_value_ext null)





Because the prop_value_ext type is null,so that create failed!





Who can tell me,where update?

Hi,





Could you provide some more detail ?





- Where and when do you get this error ?


- What is your JChem version ?


- What RDBMS are you using ?





Best regards,





Szilard

Szilard wrote:

Hi, Could you provide some more detail ? - Where and when do you get this error ? - What is your JChem version ? - What RDBMS are you using ? Best regards, Szilard

Hi Szilard,thanks for your answer.





Reply to the Q1:Initializing the Database for Structure Handling---->Create the JChemProperties table(Use the JChemManager connection the DB get this error:the prop_value_ext data type can't null)





Reply to the Q2:MSSQL Server 2000





Reply to the Q3:jchem_3_2





By the way,I can get your email luckily.





Email:zhang20084_at_126.com