Can't force data refresh from MySQL database on remote server!

[SoCalMacDude]

Filemaker docs say to call for a Refresh Window from a script to refresh the data.

 

IT DOESN'T WORK!!!  It only works when the script ends, but I need to alert the user ONLY when new data has arrived. AFTER the script runs, then the new data arrives!!  My best solution so far is to have the first script install an On Timer Script to call the next script, so when the first one quits, data comes in, and the second one then sees that. Not very elegant!

 

Anyone have a better way?

[dansmith65]

Did you select the "Flush cached external data" option in the Refresh step?

 

Are you using a supported ODBC driver to connect to the MySQL database?

 

Is Error Capture off? (if it's on, it may be "hiding" an error from you)

 

Have you tried inserting a short pause after the Refresh Window step? Not sure if this would help, but it's worth a shot.