Ax Reserved keywords for fields


image

The table defined has 3 fields and works as expected.

However if the name of the field is changed to a SQL reserved e.g. “Exit”, you will get the following error when opening the table

image

image

Errors are:

Cannot select a record in Table1 (Table1).
The SQL database has issued an error.

SQL error description: [Microsoft][SQL Native Client][SQL Server]Incorrect syntax near the keyword ‘EXIT’.

SQL statement: SELECT A.INTFIELD,A.NOYES,A.EXIT,A.RECVERSION,A.RECID FROM TABLE1 A WHERE (DATAAREAID=?) ORDER BY A.DATAAREAID,A.RECID OPTION(FAST 1)

 

For a full list of reserved words please refer to the version of SQL you are using

SQL Server 2000

SQL Server 2005

SQL Server 2008 R2

Advertisements

Leave a Reply / Comment

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s