SQL and Sage
I am using an old version of Filemaker and use SQL queries to draw data into FM from our Sage accounting package. However the scripts do not seem to hold the queries and I have to reconstruct them manually every time a different one is used for each set of data. Even running them from scriptmaker and then selecting replace when exiting does not do the trick.
Filemaker glibly says that you can use an external file to hold the SQL query and then does not state the format of the file. Not knowing the SQL language I do not know how to do this.
Can anyone shed any light on this please?