[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

How do I Test SQL in Filemaker 13?

Posted on 2014-12-14
3
Medium Priority
?
280 Views
Last Modified: 2015-01-29
Hi,

I am writing a web app that is using Filemaker as its DB, my question is, is there a way to test SQL in Filemarker much the same way you can test SQL in MySQL, MS Access etc ...

At the moment I feel like it either works or it doesn't and my methods for debugging the SQL are not great with this method.
0
Comment
Question by:Jeremy Leys
  • 2
3 Comments
 
LVL 6

Accepted Solution

by:
slinkygn earned 2000 total points
ID: 40531845
What do you mean by "test SQL in MySQL?"
As far as I know, you "test" SQL in MySQL by connecting any generic SQL client to it and seeing if you can pull up your data.  If that's what you mean, yes, you can do that with FileMaker as well.  Sounds like you'll need to go through an ODBC connector, though I'm not exactly sure what you're working with.
0
 

Author Comment

by:Jeremy Leys
ID: 40571412
What I mean is can I just execute an SQL query in Filemaker and get some output as to weather it succeeds or fails. I just want a way of being able to troubleshoot SQL queries in Filemaker.
0
 

Author Closing Comment

by:Jeremy Leys
ID: 40578524
ODBC is the answer, if connecting to Filemaker via ODBC SQL errors are returned that can be troubleshooted in the event of an SQL error.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Article by: Tammy
MySQLTuner is a script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability. The current configuration variables and status data is retrieved and presented in a brief forma…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
Suggested Courses

591 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question