Solved

Simple FileMaker ODBC question

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

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

Suggested Solutions

I have a Synology DS212+ NAS.  These are not only great for backup and normal NAS stuff, but also for delivering media throughout your home or LAN via DLNA.  I copied my whole audio collection from iTunes over to the box, but couldn't figure out how…
Many programs have tried to outwit PowerPoint in terms of technology and skill. These programs, however, still lack several characteristics that PowerPoint has possessed from the start. Here's why PowerPoint replacements won't entirely work for desi…
This video will demonstrate how to customize windows, tools, and control bars, and save them as screen sets. Open and resize windows: Customize the toolbar: Customize the control bar: Customize your tool selections: Your screen set is alread…
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…

790 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