Using FileMaker Pro as a GUI to a SQL Database

 Research  Comments Off on Using FileMaker Pro as a GUI to a SQL Database
Nov 282005
 

As of 11-17-2005, I’ve built a sample model for using FileMaker Pro as a GUI to a SQL Database using ODBC. My objective was merely to explore whether it was practical to use FMP (rather than other less “friendly” GUI applications or tedious Web-browser based HTML/PHP interfaces). I had found no useful examples on the Internet, including some FMP forums.

Scripts do SELECT (import), INSERT, UPDATE, DELETE. Some error checking even works. I’m not sure how it would scale to thousands of records, but it’s definitely easier and faster than a web-browser interface.

I purchased the Actual ODBC Driver for Open Source Databases. Jonathan Monroe at Actual Technologies (www.actualtechnologies.com) was quite helpful in confirming FMP limitations and documenting what really works and is practical regarding error returns, blobs, and security.