Importing Records into FM6 from MySQL via ODBC

[jonesy17]

I've created a new FM database and imported data via ODBC from a MySQL database, which worked great.

Then I used ScriptMaker to Execute SQL and pasted the same query from the import into the script. Here's the problem: the SQL query seems to execute, but no new records are created in FM even though I know there are new records in the MySQL database.

How do I go about actually importing the data that the SQL query retrieves? And how do I ensure that I don't get duplicate records?

Thanks in advance,

Robert Jones

[colinkeefe]

I recently did something like this, and from what I could tell, to import/update Filemaker data from mySQL, I had to use Import Records...ODBC.

Execute SQL, I think, is only for performing INSERTS, UPDATES, and DELETES on the mySQL table, not for grabbing data. But I sure could be wrong...

[jonesy17]

Well, I tried it but Import Records when run through ScriptMaker allows you to import from only a file, not an ODBC source.

Thanks for the suggestion,

Robert