• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 18. Importing and Connecting > Storing SQL Commands in Fields

Storing SQL Commands in Fields

You can type an SQL query in any field, but it's not a particularly good idea to just type the query in the way you would any other piece of data. If you make even a small syntax mistake in an SQL statement, your query won't be executed. Fortunately, FileMaker has provided SQL Query Builder—a little helper tool to create an SQL query in perfect syntax.

In this example, we'll create an SQL query to extract a subset of information from the ODBC database: the first names, last names, social security numbers and salaries of a list of employees. Once we have the query saved, we'll create an Import script to reuse this SQL query for future imports.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint