0 Replies Latest reply on Nov 7, 2013 4:49 PM by JosephMaurer

    Basic question about updating Filemaker DB using SQL query

    JosephMaurer

      Title

      Basic question about updating Filemaker DB using SQL query

      Post

           Can I use an ODBC connection to update a Filemaker DB from say Excel, or any other application?  If so, any special syntax? From Excel I got the following result.

      Worked:

           SELECT "mytable"."mycolomn"
           FROM "mytable"
           WHERE "mytable"."myothercolumn" = '1111'

      Did not work:

           UPDATE "mytable"
           SET "mytable"."mycolumn" = 'yyyy'
           WHERE "mytable"."myothercolumn" = ‘1111'