Kbase P115702: WHERE option case sensitive in Edit Table Data
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/01/2011 |
|
Status: Unverified
SYMPTOM(s):
The word WHERE can only be used in capital letters when editing table data in the DB Navigator.
Using the word "where" in other than capital letters will cause error 10713 to occur.
Syntax error in SQL statement at or about (statement excerpt). (10713)
For example:
- Start the OpenEdge Architect and connect to the sports2000 db in the DB Perspective.
- Select table ShipTo in DB Structure view.
- From the Context menu select 'Edit table data'.
- Editing dialog is displayed.
- Enter query: "where PostalCode > 2000" and press Apply button.
- See error displayed in status bar.
FACT(s) (Environment):
OpenEdge 10.1x
CAUSE:
Bug# OE00128503
FIX:
The word "WHERE" is not needed in the query. Running queries work equally fine without it.