Identifiers
When you reference Progress identifiers (for example, table fields (columns) or function names) that contain hyphens in Progress/ESQL, precede the hyphen with a backslash (\) to escape the hyphen. If you do not insert a backslash before the hyphen, the SQL preprocessor interprets the hyphen (-) as a minus sign because the hyphens permitted in Progress are not permitted in ANSI standard SQL identifiers. In the following example, a backslash is inserted in the column name cust-num so that the SQL preprocessor interprets it correctly:
NOTE: You can reference Progress-hyphenated names and language elements without escaping the hyphens by starting both the SQL preprocessor and your application using the ESQL No Padding (-esqlnopad) startup parameter. For more information, see Building and Running ESQL Applications."When including Progress identifiers in a string in C, use double backslashes ( \\ ) to escape the hyphen:
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |