What ODBC drivers are you using (both platforms)? Is the DataSource set up the same (name and permissions)?
Well, I can suggest you look into our MBS Filemaker Plugin and try the SQL commands we have there. With them you can connect to a MySQL plugin without the built in data source functions and work on the MySQL database directly with SQL commands.
It sounds like you're using the Actual Technologies ODBC driver on the Mac, in which case the trial version driver "has all features turned on, except that it will only return 3 rows from any query until the driver is registered". From memory you can contact Actual Technologies for a trial license that returns all records for 30 days or similar, otherwise if you purchase a license you'll get all the rows returned.
FileMaker 12/11/10/9/8 Certified Developer
- - - - - - - - - - - - - - - - -
Phone: +61 2 9484 6565
Mobile: +61 418 468 103
I've used the Actual Tech drivers they work wonderful. And the cost is reasonable.
That's the answer. The IT person at the client's office set my Mac up, and the ODBC driver he used I'm pretty sure was an Actual Techologies one. (I'm still learning how to work with SQL and don't know how to see what drivers I've got.) I didn't know that it was only a trial version though. For the limited time I'll likely be involved I'll work on the PC, though speed of development will suffer a little. Without trying to start a platform war, the three PCs I've used on this client's system weren't as easy to use as my MacBook Pro.
And thanks to all the others who responded. If I'm involved in the long term I'll look at getting the full Actual Techologies licence.