Kbase 15702: Hyphenated names invalid in SQL ( Embedded SQL) -esqlnopad
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Hyphenated names invalid in SQL ( Embedded SQL) -esqlnopad
As stated in the documentation, standard SQL support assumes that a
hyphen is a minus sign. When a field name such as cust-num is used
in an ESQL statement, the hyphen is blank-padded and becomes
cust - num (cust minus num) which results in a pre-processor error.
Note: This is *not* a problem when using SQL syntax from within the
PROGRESS 4GL. It is only a problem when using ESQL.
There are two options to avoid this problem:
1> Start your PROGRESS session with the -esqlnopad option which
will allow hyphenated-names but will require you to blank-pad all
true minus signs to separate them from their operands. For example:
qty-ordered - qty-shipped.
2> Alternatively, you can "escape" the hyphen in the field or table
name by using the \ (backslash) character, i.e.: cust\-num.
Refer to Version 7 or Version 8 Embedded SQL Guide and Reference
pages 3-13 and 3-20 for further information.
Progress Software Technical Support Note # 15702