Operating Condition
Syntax: SET IDQUOTES
Default: 7.6: Back Quote (`) Prior: NULL
Controls the character that is used to set off object names.
IDQUOTES sets the character for enclosing object names, such as column or table names, in R:BASE and ODBC commands. This is especially critical when using ODBC to connect to a non-R:BASE Database that allows characters such as spaces in Column or Table naes. This is also critical to SOME internal R:BASE processing.
Note: Older databases may default to NULL which is not ODBC or SQL compliant.
In general, setting IDQUOTES will have no effect on legacy applications as they will not, in most cases, know that this exists. The one exception to this is UNLOADing data from a database that has IDQUOTES set, such as an upgraded R:BASE 2000 database, and importing into a Legacy database. If you are attempting to do this you should set your IDQUOTES to NULL.
The Back Quote is the Reverse Single Quote that is located, on most standard US Keyboards, under the Tilde (~) character and to the left of the numeral 1.
