AnsweredAssumed Answered

Table name 'user" - ExecuteSQL command does not work

Question asked by jake on Nov 20, 2012
Latest reply on Nov 20, 2012 by philmodjunk


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)