I am working on a project where both mySQL and SQLite data sources shoud work and while the mySQL tables and columns are resolved in query statements the SQLite are not resolved.
I can manage both data sources connection in Database Tool Windows, I can also add and modify tables in SQLite but when I try to insert statement related to SQLite tables I cannot get any Code completion suggestion and, then, the name of tables and fields are marked as "unresolved reference".
I also try the "Invalidate cache / Restart" command with non success.
Thanks for support,
p.s.: I also checked the Console recalled from Database Tool Window and I got working reversed!! The resolved references were the SQLite ones while the unresolved references were the mySQL ones!! May be it is an issue and I will have to place there the question. Let me have your comment, if you are confident on similar cases. Thanks
Modified by Carmine IACIOFANO
Attachment(s):Schermata 2015-04-06 a 14.06.10.png