ODBC export to mySQL... need some scripting help.

[Randy Lahey]

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

[mpascal]

I didn't know about myodbc

Do you use Mac or PC?

http://dev.mysql.com/doc/connector/odbc/en/faq_2.html#SEC40

I am just learning myself.

The last couple of days I've been playing with the mysql driver from Actual Technologies

http://www.actualtechnologies.com/product_opensourcedatabases.php

I was able to import and do inserts like this

Scriptmaker -> execute sql -> calculation

"INSERT INTO `mysql_table_name` (`mysql_field_name`) VALUES ('" & fmp_field_name & "');"

Marino