Solved

Simple FileMaker ODBC question

Posted on 2012-04-04
2
585 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 24

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

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…
Keep your audience engaged and get the most out of your next presentation with these quick Prezi tips.
Viewers will learn how to turn a Live Set into a compressed Live Pack file, and how to install Live Packs. Make: File > Collect All And Save: File > Manage Files: Click Manage Project: Click Create Pack: Select save location: Install: Doub…
Viewers will get an overview of how to make and use Drum Racks in Ableton Live. Load new Drum Rack into empty MIDI track: Fill rack with audio samples: Re-arrange sample slots as necessary: Adjust parameters of each slot to tailor each sound a…

911 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

21 Experts available now in Live!

Get 1:1 Help Now