2 Replies Latest reply on Dec 2, 2013 6:49 PM by user19752

    FileMaker SQL ODBC Catalog Functions

    IanJempson

      Has anyone had any luck using the ODBC catalog functions listed on page 54 of the fm12_odbc_jdbc_guide ?

       

      It lists the following, but no example syntax...

       

      ODBC Catalog functions

      The ODBC client driver supports the following Catalog functions:
      1 SQLTables - catalog information is stored and reported as single part names (table name only). 1 SQLColumns
      1 SQLColumnPrivileges
      1 SQLDescribeCol
      1 SQLGetTypeInfo

       

      Do these provide anything more than we already get with SELECT * FROM FILEMAKER_TABLES or SELECT * FROM FILEMAKER_FIELDS ? What syntax do we need to use?

       

      thanks

      Ian