As long as you have table occurrences in your file you can refer to those table occurrences in calculations and they will evaluate normally whether the table occurrence is for a table defined in the current file or an external data source reference to a table in a different file.
But it sounds like you are not putting the SQL query inside quotes so that it is a quoted string given the error message that you report.
Thanks Phil, indeed I did not notice the quotes in the documentation. however I must still be doing something wrong.
A simple SELECT statement does work with the * wildcard ( returns all de colums for the two records of my table ) but not when I try name the fields/columns.
You can see the two statements in the data viewer in the attached file.
It is often necessary to enclose table and/or field names inside quotes to avoid SQL syntax errors.
"SELECT \"q_ID_Quantite\" ...
It does not make a difference in my case, but that helped me to find the problem. Accented characters. I removed the accented characters in the manage database dialogs and it words as intended. Maybe accented characters are seen as a simple quote followed the the character.
Thanks for your help
I thought that that would be the cause, but hoped that quoting the name would resolve the problem.
I recommend reporting this over in Report an Issue as a possible bug.