Solved

Simple FileMaker ODBC question

Posted on 2012-04-04
2
592 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
2 Comments
 
LVL 25

Accepted Solution

by:
Will Loving earned 500 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

Technology Partners: 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

Suggested Solutions

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Viewers will learn how to create a new project within Adobe Encore and the basic layout of the software.
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…

749 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