Kbase P5658: Error 7587 with Windev
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/2/2005 |
|
Status: Unverified
SYMPTOM(s):
Error (7587) when running a query from Windev
Syntax error (7587)
Using single quotes in a query
Using SQL-92
CAUSE:
When a field name contains hyphen (-), it has to be enclosed in double quotes.
However the Windev software generates a compilation error when adding them.
When adding single quotes ('), the compiler does not complain anymore. However progress does, and the error 7587 occurs.
FIX:
Add the CHARACT(34) function , equivalent to double quote ("), in the query string, such as:
sSQL = "SELECT " + charact(34) + "cust-num" + charact(34) + " FROM PUB.customer"