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

    Table name 'user" - ExecuteSQL command does not work



      Table name 'user" - ExecuteSQL command does not work


      FileMaker Pro



      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



      change table name to users or user2(not ideal)