Kbase P184394: 4GL/ABL: Error (8826 executing a SELECT statement from the Procedure Editor
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/18/2011 |
|
Status: Unverified
SYMPTOM(s):
4GL/ABL: Error (8826 executing a SELECT statement from the Procedure Editor
Field <field-name> from <file-name> record (recid <RECID>) was missing from FIELDS phrase. (8826)
Field user-num from _sqlbuf13 record (recid nnnnnn) was missing from FIELDS phrase. (8826)
Executing a statement like:
SELECT * FROM Customer
Issue was occurring only from one client session. Other client sessions execute the same SELECT statement without error.
FACT(s) (Environment):
After closing the session and starting a new one, the same SELECT statement executed without error.
Windows
OpenEdge 10.1C04
CAUSE:
Unknown. A possibility is the network communication between the offending client session and the remote Database Server may have had some problems.
FIX:
Although the SQL-89 engine that allows the execution of SQL SELECT queries from the OpenEdge Procedure Editor is still available in OpenEdge 10.x, it has been deprecated in OpenEdge 10.x. It is highly recommended to use SQL-92 ODBC or JDBC client when SQL access to the database is desired.