?
Solved

Simple FileMaker ODBC question

Posted on 2012-04-04
2
Medium Priority
?
602 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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

Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
Keep your audience engaged and get the most out of your next presentation with these quick Prezi tips.
Viewers will learn how to create and use Simpler instruments in Ableton Live. Load new Simpler into an empty MIDI track: Select a sample and drop it into sample window in Simpler: If sample is not pitched at C3, adjust tuning with Transpose para…
Viewers will learn how to use LFOs to modulate the sound of their Sampler instruments. Click the Modulation tab in Sampler: Choose one (or more) of the three available LFOs, and click the respective button to turn it on: Select a waveform, an LF…
Suggested Courses
Course of the Month10 days, 16 hours left to enroll

770 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