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

Chapter 18. Importing and Connecting > About FM5.5's ODBC Functions

About FM5.5's ODBC Functions

Setting up an ODBC (Open Database Connectivity) database is considerably more difficult than setting up a FileMaker one, and frequently requires the services of a specialized programmer. It would be next to useless if it also required a programmer to mine information from the database once it's up and running. Fortunately, there is SQL (Structured Query Language)—a language designed to make that task a lot easier. A tiny warning: SQL is still not as friendly and intuitive as FileMaker—you have to become familiar with its syntax and commands to use it effectively. But it isn't particularly difficult to learn, and is worth the effort if you need to get files from an ODBC database.

Prior to FileMaker 5.5, special plug-ins were required to interact with an ODBC database using SQL. The current advances allow you to use SQL commands to both import and export information between a FileMaker and an ODBC database, and to use SQL to mine a database for very specific sets of information.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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