1 2 3 Previous Next 42 Replies Latest reply on Apr 24, 2016 1:46 PM by twelvetens

    ODBC/SQL XML Data Type

    twelvetens

      I'm using ODBC to connect to a MSSQL instance. Using ESS to display tables/layouts etc.

       

      This works fine with dozens of tables and their respective fields, but now I'm looking at a specific table that has 6 fields of type 'bit', and then one with type 'xml' (see attached screen shot). When I view these fields in SQL Studio Management I can see all the XML, but when I try and view this table using ESS (in Filemaker) I only see the 'bit' fields, not the 'xml' field.

       

      Is this a limitation of ODBC / ESS in Filemaker? I've tried using ExecuteSQL to grab the data based upon the field name, but still no joy.

        1 2 3 Previous Next