Hey folks;
I'm currently using myodbc to link fmp and a mysql database.
I've been able to easily import sql tables into a fmp db... no problem there.
My problem is in exporting back from fmp into a mysql table. I want to do this via odbc, not csv or any other means that involves extra steps.
In terms of SQL script, I think that what I want to do is TRUNCATE sql_table, followed by INSERT into sql_table.
What I can't figure out is how to script that from within FMP7... I can't make any sense of scriptmakers sql calculation area, which I assume is where one has to link FM fields to SQL columns. How, exactly do I build a script that funnels FM fields into the corresponding SQL column?
I am not a whiz with either FMP or SQL, but I think I can patch this together if someone would be kind enough to get me started.
thanks in advance,
Randy
