Some characters require special handling within DATA tags.
| " | Avoid using double quotation marks within an SQL statement, to avoid confusion with the double quotes enclosing the entire query. It is possible to use an escaped quotation mark \" within this string, which is interpreted as a single " character. |
| ' | The single quotation mark is used to delimit strings within the SQL string. If the string actually contains an apostrophe, for example,
NAME='It's' use the escaped quotes for the outer quotes: NAME=\"It's\" |
| CR/LF | Embedded carriage return/line feeds are handled by memo fields of most databases, provided that the Browser used is DOS or Windows based. Results using Unix browsers may be unpredictable. |
| {} | Curly braces are variable replacement delimiters. If you need them within a string (for instance to name an ODBC driver) then used the escaped characters \{ and \} |
| < > | These are HTML tag delimiters. If you need them within a RES-Reach tag (for instance as a comparison operator for SQL) then use the escaped characters \> and \<. |
| dates | To avoid conversion problems, dates must be represented using a format function on input and output to databases,
[Date] = format$('{Date_Field}', 'dd mmm yy') |