AnsweredAssumed Answered

Is there an easy way to display SQL Select Results

Question asked by aammondd on May 12, 2010
Latest reply on Apr 19, 2011 by RestaurantCharlie

Title

Is there an easy way to display SQL Select Results

Post

Im racking my brain for a way in FM to allow for the construction of a SQL statement and display the results independent of table in FM in say table format.

 

Ive been using sql queries for years  to do data analysis and know that I can technically use a Filemaker File as an ODBC source and it supports sql commands I was just trying to figure out how I would be able to execute a user derived sql statement and have the results display in FM.

 

Any thoughts?

 

I know this may be asking a lot of the application but when working on files with lots of tables and data sometimes its simply best to construct the sql to find out where the problem lies. 

 

 

Outcomes