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

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)

Outcomes