AnsweredAssumed Answered

Basic question about updating Filemaker DB using SQL query

Question asked by JosephMaurer on Nov 7, 2013

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'

Outcomes