I just need to confirm something. I have a FM file that has an ODBC connection to a MySQL DB. I have the MySQL tables/views open in the files as table occurrences and I need to do a find on one of the MySQL tables and if there are more records in the MySQL table, FM will import that records from the MySQL DB into the FM DB.
Running the script on my machine works fine, but when I schedule the script to run on the server, I get an error 100 every time the script run. I have been trying to figure this one out, and I need to double check to make sure I am understanding this correctly.
FMS does not allow importing from one table to another? Is that correct? I have read a lot today about FMS only being able to import from folders?
Does this mean I need to export the found set, and then import the set when done?