Writing data via SQL/ODBC connection into an FM database.
I am trying to write an application using FileMaker as a front end and python as a back end to work with web services and other APIs. Both the FM front end and python back end are local to one machine. I'm using the pyodbc module in python to interact with the SequeLink ODBC driver. I am able to retrieve data from the FileMaker database without any problems, but am not able to insert data into the database. Further, I am getting no error messages. Does anyone have tips for how to resolve this problem?
OS: Windows XP, SP3
Filemaker Advanced 9.0v3