Kbase P145573: Temp-Table buffer-value always returns the initial value "today" of a date field as "14/02/01" when
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/06/2009 |
|
Status: Unverified
SYMPTOM(s):
Temp-Table buffer-value always returns the initial value "today" of a date field as "14/02/01" when connecting to the SQL Database Schema Holder
Run the code below always returns 14/02/01 when connecting to the schema holder.
DEFINE VARIABLE M-HANDLE AS HANDLE NO-UNDO.
DEFINE VARIABLE M-BUF AS HANDLE NO-UNDO.
DEFINE VARIABLE M-FIELD-HANDLE AS HANDLE NO-UNDO.
CREATE TEMP-TABLE M-HANDLE.
M-HANDLE:ADD-FIELDS-FROM("newtable").
M-HANDLE:TEMP-TABLE-PREPARE("T-newtable").
M-BUF = M-HANDLE:DEFAULT-BUFFER-HANDLE.
M-BUF:BUFFER-CREATE.
m-field-handle = m-buf:buffer-field("f_transaction_date").
message m-field-handle:buffer-value view-as alert-box.
FACT(s) (Environment):
OE Database has a date field use Today as initial value.
Push the OE database to MSSQL Database (SQL2000, SQL2005) using Schema Migration Tools -> OpenEdge DB to MS SQL Server.
All Supported Operating Systems
OpenEdge 10.1x
OpenEdge 10.2A
CAUSE:
Bug # OE00183774
FIX:
Upgrade to 10.1C04.
After upgrade to 10.1C04, for an exsiting schema holder the following steps needed to be taken:
1. Connect to the existing schema holder
2. Choose the MSS database from 'Select Working Database'
3. And then does update on the table contains the date field with initial value 'today'. DataServer -> MS SQL Server Utilities -> Update/Add Table Definitions...