Creating SQL Entities containing structures

Hi,

I followed the instructions for creating new (virtual) SQL entites from existing tables (https://www.chemaxon.com/instantjchem/ijc_latest/docs/user/help/htmlfiles/editing_database/editing_entities.html#settings).

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:

• Fixed a bug when Cd_structure column is wrongly identified as binary field when promoting MySQL view.

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.

 

Hi,

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.

Thanks,
Filip 

Filip,

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

Thanks!

Evert,

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

Thanks for your understanding.