Technical Support Forum Index
Technical Support Forum
Access ChemAxon scientists and developers here. For registration and login issues contact website support.
Overlap analysis problem
To watch this topic for replies  Register (enables digests) or give email address:
Reply to topic
Display posts from previous:   
    View previous topic :: View next topic    
Author Message
HomerE

Joined: 15 Feb 2008
Posts: 174

View user's profile
Visit poster's website

Back to top
Link to postPosted: Tue Jun 09, 2009 7:23 amPost subject: Overlap analysis problem Reply with quote

Hi,

I performed an overlap analysis between 2 databases (IJC version 2.5.1), the query being a local database and the target a mySQL-based one (both on Linux). I requested the Cdid's of the target database to be added as a new field in the query database. This did happen, but the field type is specified as 'tt' (varchar(4000)) which doesn't allow me to sort it properly. Since the Cdid's generated by IJC always are integers, why isn't this field type just copied as well? Is there a way to convert field types on existing columns?

Thanks,

HomerE

tdudgeon
ChemAxon personnel
Joined: 05 Oct 2004
Posts: 1673

View user's profile
Visit poster's website

Back to top
Link to postPosted: Tue Jun 09, 2009 8:25 amPost subject: Reply with quote

A text column is used as there can be multiple values reported, and this cannot be done using a standard integer column. For instance if your target table contains duplicates, or if you are running a similarity search then you would expect some entries to have multiple hits.

If you are abolutely sure that in your case you only have a single hit in each case then you can try converting the text column to an integer column after it is created. Right click on column header in grid view, or on the field in the schema editor and choose 'Convert type'.

 

Tim

 

Reply to topic
Page 1 of 1


To watch this topic for replies   Register (enables digests) or give email address  
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum