How to catch a result of script step [Execute SQL - SELECT...] into FileMaker field?

Posted on 2008-11-17
Last Modified: 2012-05-05
I succesfuly connected my FileMaker Pro 8,5 Adv or 9 with MySQL server.
I can thru script "Execute SQL" make INSERT, UPDATE, DELETE on MySQL server.
I need read data from MySQL server by using SELECT statement in "Execute SQL" script.
Where in FileMaker is result of this (SELECT) statement?
How can I write result into FileMaker field or variable?

(I know about Import Record Script step, but I want use Execute SQL script step.)
Question by:karel777
    1 Comment
    LVL 28

    Accepted Solution

    this is an exception in the FM/sql stuff, you should use the ODBC source in the import function to insert your query.
    file/import/odbc > you'll get a wizard, but you can type your query manually; you will have to match imported records with those of a local table.
    note that using v9, you can declare the odbc source as an external data source, create a table occurence in your relationship graph, then a layout for it, then find records as local data from there. much easier than using SQL.
    Just watch for large tables, FM finds * when you first display the layout of a table, and if the SQL source is 500000 lines, it might be lengthy, so better issue a search before showing the layout.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Suggested Solutions

    Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (, A SQLite Tidbit: Quick Numbers Table Generation (…
    This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    758 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

    14 Experts available now in Live!

    Get 1:1 Help Now