Kbase P109955: OpenEdge DB Navigator: 'Generate select in SQL Editor' for selected table do not quote the field nam
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
20/03/2008 |
|
Status: Verified
FACT(s) (Environment):
OpenEdge 10.1x
Windows NT 32 Intel/Windows 2000
SYMPTOM(s):
In DB Navigator, 'Generate select in SQL Editor' does not quote the field names
Only the table name is enclosed in double quotes
Table contains field names with hyphens
When running the select query generated, the error 7520 appears:
Column not found/specified (7520)
CAUSE:
This is expected behavior. By default, the fields are not enclosed in double quotes.
In SQL-92, if the table, or field, names contain special characters such as hyphens, then they should be enclosed in double quotes.
FIX:
Modify the preferences for the OpenEdge DB Navigator, and check the 'Enclose in quotes' option.
The steps to follow are:
- Click on the menu 'Window'
- Select 'Preferences'
- Expand the 'OpenEdge' item
- Click on the 'DB Navigator' item
- Check the 'Enclose in quotes' option
- Apply the change, and close the Preferences dialog-box