1 Reply Latest reply on Apr 2, 2012 1:24 PM by beverly

    SQL for beginners

    Hudi

      I'm a developer with about 1.5 years of experience and I want to learn SQL and how it integrates with Filemaker. I know SQl on a basic level but have yet to see how it connects with FM. From I've been reading its pretty powerful.If anyone has any advice on how to start I would be most grateful.

      thanks a bunch!

        • 1. Re: SQL for beginners
          beverly

          Brushfire, the are two main methods of using SQL & FileMaker.

           

          1. FileMaker as ODBC source.  - other applications communicate with FileMaker database set to sharing with ODBC.

           

          2. FileMaker communicating with another database that has been set up as ODBC source.

           

          JDBC can also be used.

           

          See this link for a starting point

          http://www.filemaker.com/support/technologies/odbc.html

           

          Follow the links, download the guides.

           

          There are also plugins that allow SQL statements to be used inside FileMaker to itself.

           

          Research 'filemaker SQL' in your favorite search engine for a lot of information!

           

          If you've already read up on the guides and have specific questions, let us know!

           

          -- sent from my iPhone4 --

          Beverly Voth

          --