executesql () function and external (filemaker) data source
I am trying to use the executesql() function and right after evaluation the SELECT statement, I get an error message "the specified table cannot be found"
After having tried to provide table names instead of table occurence names without succes, I realised that the cause of the problem might be that there are not tables in my file, all the tables are in an external , filemaker, data source, as I have split the user interface an logic from the data.
Is my diagnose of the problem correct, is there a solution? I am afraid I painted myself in a corner.