Ax Reserved keywords for fields

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

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