ContentsIndexPreviousNext

A_DBM_QUOTE_IDENTIFIERS

The configuration variable A_DBM_QUOTE_IDENTIFIERS tells Acu4GL for DBMaker whether to test for the IDENTIFIER-QUOTE-CHAR, and to use it if it is found. If this variable is non-zero, and if the driver returns information about the IDENTIFIER_QUOTE_CHAR, identifiers sent in SQL to the driver are quoted. This is useful for using MS Excel, for example, if the spreadsheet has column names with quotes or other strange characters. Notice that some drivers mistakenly report that they can handle quoted identifiers, which is why this variable is needed. If you set this variable to a non-zero value, and start getting errors about table not found or column not found, this variable should not be used when communicating with that driver. While the default value is "0" (off, false, no), this configuration variable can also take values of "On" (true, yes).