Product Information > Version 7.1 Release Information > Upgrading to JADE Release 7.1 > RPS Keywords (PAR 64608)

RPS Keywords (PAR 64608)

In earlier releases, reserved T‑SQL keywords (for example, the word 'file' in the query UPDATE BKdocument SET file=? WHERE oid = ?) were not quoted in RPS.

The third sheet of the System DSN wizard in the ODBC Data Source Administrator (the Data Sources (ODBC) program in the Windows Administrative Tools) now has the configurable Use ANSI quoted identifiers check box, which enables RPS to interrogate the RPS ODBC data source that it uses to determine if to quote SQL identifiers (that is, table, column, and procedure names). This allows reserved T‑SQL keywords to be used in SQL statements, which is useful if you want a property to have the same name as a T‑SQL reserved word.