{"id":236,"date":"2005-11-28T12:18:58","date_gmt":"2005-11-28T20:18:58","guid":{"rendered":"http:\/\/www.digivideoplus.com\/dv_blog\/?p=236"},"modified":"2011-06-12T18:07:08","modified_gmt":"2011-06-13T01:07:08","slug":"using-filemaker-pro-as-a-gui-to-a-sql-database","status":"publish","type":"post","link":"https:\/\/www.digivideoplus.com\/dv_blog\/2005\/11\/28\/using-filemaker-pro-as-a-gui-to-a-sql-database\/","title":{"rendered":"Using FileMaker Pro as a GUI to a SQL Database"},"content":{"rendered":"<p>As of 11-17-2005, I&#8217;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 &#8220;friendly&#8221; GUI applications or tedious Web-browser based HTML\/PHP interfaces). I had found no useful examples on the Internet, including some FMP forums.<\/p>\n<p>Scripts do SELECT (import), INSERT, UPDATE, DELETE. Some error checking even works. I&#8217;m not sure how it would scale to thousands of records, but it&#8217;s definitely easier and faster than a web-browser interface.<\/p>\n<p>I purchased the Actual ODBC Driver for Open Source Databases. Jonathan Monroe at Actual Technologies (<a href=\"http:\/\/www.actualtechnologies.com\" title=\"www.actualtechnologies.com\" rel=\"external\">www.actualtechnologies.com<\/a>) was quite helpful in confirming FMP limitations and documenting what really works and is practical regarding error returns, blobs, and security.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>As of 11-17-2005, I&#8217;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 &#8220;friendly&#8221; GUI applications or tedious Web-browser based HTML\/PHP interfaces). I had found no useful examples on the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[29],"class_list":["post-236","post","type-post","status-publish","format-standard","hentry","category-research","tag-filemaker"],"_links":{"self":[{"href":"https:\/\/www.digivideoplus.com\/dv_blog\/wp-json\/wp\/v2\/posts\/236","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.digivideoplus.com\/dv_blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.digivideoplus.com\/dv_blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.digivideoplus.com\/dv_blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.digivideoplus.com\/dv_blog\/wp-json\/wp\/v2\/comments?post=236"}],"version-history":[{"count":3,"href":"https:\/\/www.digivideoplus.com\/dv_blog\/wp-json\/wp\/v2\/posts\/236\/revisions"}],"predecessor-version":[{"id":339,"href":"https:\/\/www.digivideoplus.com\/dv_blog\/wp-json\/wp\/v2\/posts\/236\/revisions\/339"}],"wp:attachment":[{"href":"https:\/\/www.digivideoplus.com\/dv_blog\/wp-json\/wp\/v2\/media?parent=236"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.digivideoplus.com\/dv_blog\/wp-json\/wp\/v2\/categories?post=236"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.digivideoplus.com\/dv_blog\/wp-json\/wp\/v2\/tags?post=236"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}