3 Replies Latest reply on Nov 4, 2009 7:02 AM by TSGal

    SQL For Accessing FileMaker Schema Info?

    trevordevore

      Title

      SQL For Accessing FileMaker Schema Info?

      Post

      Hi,

       

      I'm looking at adding support for FileMaker over ODBC to a product of mine. I have successfully connected to a FileMaker Pro 10 database using ODBC on OS X. I'm aware that FileMaker supports the ODBC Catalog functions such as SQLTables, SQLColumns, SQLDescribeCol, etc. I happen to have a driver that doesn't implement all of those functions though.

       

      I'm wondering if FileMaker supports any SQL calls that will return schema info? For example, in MySQL you can use 'SHOW FULL COLUMNS FROM...' and in PostGreSQL you can use 'SELECT * FROM information_schema.columns...'. Any equivalent in FileMaker?

       

      Thanks.