Solved

How do I Test SQL in Filemaker 13?

Posted on 2014-12-14
3
177 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:jwleys
  • 2
3 Comments
 
LVL 6

Accepted Solution

by:
slinkygn earned 500 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:jwleys
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:jwleys
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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
This article discusses how to create an extensible mechanism for linked drop downs.
The viewer will learn how to count occurrences of each item in an array.
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…

863 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

Need Help in Real-Time?

Connect with top rated Experts

29 Experts available now in Live!

Get 1:1 Help Now