Kbase P148657: NUM-ENTRIES function returns 1 for blank records when used against ODBC DataServer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/25/2009 |
|
Status: Unverified
SYMPTOM(s):
NUM-ENTRIES function returns 1 for blank records when used against ODBC DataServer
Unable to concatenate database character field data from AS/400 with literal to form a procedure name to run
Using Progress/400 DataServer can concatenate database character field data with literal to form a procedure name to run.
ODBC DataServer accessing files created via DDS
FACT(s) (Environment):
The ODBC DataServer is connecting to DB2/400
The code use with FOR EACH is
MESSAGE NUM-ENTRIES(field name) VIEW-AS ALERT-BOX.
OpenEdge 10.x
Windows
ODBC DataServer
CAUSE:
Bug# OE00186670
FIX:
As a workaround use TRIM with NUM-ENTRIES as:
FOR EACH table NO-LOCK:
MESSAGE NUM-ENTRIES (TRIM(field)) VIEW-AS ALERT-BOX.
END.