Kbase 21997: ADM2: Unknown Value (?) Retrieving Data from an Oracle View
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
30/04/2002 |
|
SUMMARY:
When you develop applications with ADM2 and retrieve data from an ORACLE View you might get unknown values (?) into the data fields.
EXPLANATION:
This could happen when the ORACLE View contains "date" type columns
which will have 2 corresponding columns in the Progress schema holder: one for date and another one for time. This is because the "date" type columns also contain the time-stamp in. ADM2 uses BUFFER-COPY to transfer data from database to row object ( temp-table ) and this causes some fields to get unknown values.
SOLUTION:
There are a couple of solutions to this problem:
-- Delete from the schema holder all "-1" fields that are the correspondents of the time-stamp portion from a date type column in ORACLE. This is the most reliable remedy if you can apply it.
-- If you need to keep "-1" fields, use ASSIGN statements in the transferDBRow procedure after the standard behavior section. For example:
ASSIGN RowObject.order_date-1 = orderview.order_date-1.
where orderview is the ORACLE View table in schema holder.