Kbase P59472: DATE not copied correctly with BUFFER-COPY
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
FACT(s) (Environment):
Oracle DataServer
SYMPTOM(s):
DATE not copied correctly with BUFFER-COPY
Depending on the client (Win32 or Unix), the date copied is different.
DEFINE TEMP-TABLE tt NO-UNDO LIKE tablX.
BUFFER-COPY tablX EXCEPT tablX.dateY TO tt.
Fields dateY DATE and dateY-1 INTEGER within schema holder
CAUSE:
As the field dateY-1 is holding a part of the Oracle date, the DataServer does not put the NULL or DEFAULT date within the Temp-Table record.
FIX:
BUFFER-COPY tablX EXCEPT tablX.dateY tablX.dateY-1 TO tt.