Kbase P120011: Automatic Temp-table created using temp-handle loses the original fields format
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/17/2010 |
|
Status: Verified
SYMPTOM(s):
Automatic Temp-table created using temp-handle loses the original fields format
INITIAL value for a character FORMAT is "99:99" but returns "00::0".
INITIAL value for a character FORMAT ":9" returns "::"
INITIAL value for a character FORMAT "<anychar>9" returns "<anychar><anychar>"
FACT(s) (Environment):
The code below shows the issue:
DEFINE VARIABLE hBuffer AS HANDLE NO-UNDO.
DEFINE VARIABLE hField AS HANDLE NO-UNDO.
/* Works if against the actual DB table,
fails against temp-table defined like DB table or if individual
fields defined with like or if fields have format and inital value */
DEFINE TEMP-TABLE ttschedord NO-UNDO RCODE-INFORMATION
FIELD inv-time AS CHARACTER FORMAT "99:99" INIT "00:00".
DO TRANSACTION:
CREATE BUFFER hBuffer FOR TABLE "ttschedord".
hBuffer:BUFFER-CREATE().
ASSIGN hfield = hbuffer:BUFFER-FIELD("inv-time").
MESSAGE "init" hfield:INITIAL
"format" hfield:FORMAT VIEW-AS ALERT-BOX INFO BUTTONS OK.
/* INIT IS 00:00 in v9 and 00::0 in 10.0X, 10.1A & 10.1ASP1 */
UNDO, LEAVE.
END.
It works fine with Progress 9.1E SP 02
Happens to any field type
All Supported Operating Systems
OpenEdge 10.0x
OpenEdge 10.1A
CAUSE:
Bug# OE00131092
FIX:
Upgrade to OpenEdge 10.1A02 or 10.1B or later