1 Reply Latest reply on Nov 20, 2012 10:05 AM by philmodjunk

    Table name 'user" - ExecuteSQL command does not work

    jake

      Summary

      Table name 'user" - ExecuteSQL command does not work

      Product

      FileMaker Pro

      Version

      12

      Operating system version

      Mac OS X 10.6 (snow leopard)

      Description of the issue

      Filemaker ExecuteSQL command does not work when calling a table with the name 'user'

      Steps to reproduce the problem

      Create a table in Filemaker called 'user'
      add a couple of fields and some data

      Then run a ExecuteSQL ( sqlQuery ; fieldSeparator ; rowSeparator { ; arguments... } ) command that looks something like this

      ExecuteSQL ( "SELECT * FROM user" ; "" ; "" ; "" )

      This returns an error "?"

      if you change your table name to users then it works

      'user' is not a reserved keyword in SQL

      Expected result

      All data in table user should show

      Actual result

      ?

      Exact text of any error message(s) that appear

      ?

      Workaround

      change table name to users or user2(not ideal)