Solved

How do I Test SQL in Filemaker 13?

Posted on 2014-12-14
3
168 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
Comment Utility
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
Comment Utility
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
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
These days socially coordinated efforts have turned into a critical requirement for enterprises.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

763 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

12 Experts available now in Live!

Get 1:1 Help Now