Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Simple FileMaker ODBC question

Posted on 2012-04-04
2
Medium Priority
?
607 Views
Last Modified: 2012-04-13
Hi

Is it possible to run SQL SELECT commands from an Execute SQL command that return a recordset that is the source for later logic in a script?

If not, are there any alternatives?
0
Comment
Question by:butterhook
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 25

Accepted Solution

by:
Will Loving earned 2000 total points
ID: 37810723
My knowledge in this area is somewhat limited but let me start by clarifying that you are wanting to use the Execute SQL script step on External SQL data source which you have added/connected to your FileMaker file using the ODBC External Data Sources option, such that the SQL source appears as a Table and on the relationship graph. Is that correct? If so, and you have a layout for that external table (or "shadow" table as it's sometimes called) then you should be able to use either a SELECT command or a standard FileMaker Find on the records and then perform other scripted operations on the Found Set of records.

Here's is a short article with a much longer linked PDF file at the end on the use of SQL in FileMaker:

http://proofgroup.com/blog/2009/nov/introduction_sql_filemaker_developers

There is also FileMaker, Inc.'s own white paper on the topic:

http://www.filemaker.com/downloads/documentation/techbrief_intro_ess.pdf

If you are a subscriber to Matt Petrowsky's FileMaker Magazine (very worthwhile) he has a very in-depth video introduction to FM and SQL:

http://www.filemakermagazine.com/videos/using-sql-within-filemaker.html
0
 
LVL 1

Author Closing Comment

by:butterhook
ID: 37843067
Thanks!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Keep your audience engaged and get the most out of your next presentation with these quick Prezi tips.
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
Viewers will learn the basics of creating custom device Racks in Ableton Live. Place instrument(s) and effects onto a track, and select them all by holding the Shift key and clicking on the device title bars: Group them by typing Command-G (Ctrl-G…
Viewers will learn how to include realistic velocity sensitivity to their Sampler instruments. Set the Vol<Vel parameter in the Filter/Global tab to your desired setting: Gather samples of hits of various intensity, and drag/drop into Velocity zon…
Suggested Courses

618 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