Creating SQL Entities containing structures

User 8a7878ec6d

22-09-2013 18:25:30


I followed the instructions for creating new (virtual) SQL entites from existing tables (

This works fine for tables that do not contain structures, but I would like to add structures to the SQL entity.

According to the release notes for 6.1 as bug has been fixed in this context:

However, I cannot get this to work for tables containing structures. The cd_structure field is still recognized as binary field, and a structure-type field is not among the choices (see below).

Is there more to it for tables containing structures? Please advice!

This is IJC 6.1, with local Derby database format, on Win7 64-bits.


ChemAxon 2bdd02d1e5

26-09-2013 10:25:32


I'm sorry, SQL Entity currently not support structures. There has been misunderstanding of what was fixed.
If you have a mysql db view on top of a structure table. The entity created from that view would look like a structure entity, except the search would not work. (Formerly in looked like a standard entity) .

MySQL DB view is different from in-line view, which is used in SQL Entity.

I'll take this as suggestion for improvement of SQL Entity.


User 8a7878ec6d

09-04-2014 09:45:07


Will there be support for handling structures in SQL Entities in 6.3?


ChemAxon 2bdd02d1e5

09-04-2014 12:32:40


I'm sorry, this is not currently in the pipeline, not for 6.3 nor for 6.4.

Thanks for your understanding.