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

    FileMaker SQL ODBC Catalog Functions


      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?