Kbase 13811: Input Value Not Long Enough For Date Format (1252)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Input Value Not Long Enough For Date Format (1252)
The Oracle DATE datatype contains both the date and time information.
In the schema holder, an Oracle DATE column is represented by two
Progress fields: a DATE field and an INTEGER field. The Dataserver
follows this convention when naming the fields: column column-1.
For example, an Oracle date column named DATE_DUE converts to two
fields named DATE_DUE and DATE_DUE-1. DATE_DUE is a DATE field and
DATE_DUE-1 is an INTEGER field.
When using the Oracle dataserver the TIME portion of a Date/Time
colume cannot be used in the WHERE clause. This is a documented
restriction (see Dataserver for Oracle Guide).
For example:
FIND FRIST tableC WHERE tableC.datefield1 = 01/01/95 AND
tableC.datefield1-1 = 1.
will return error:
ORACLE error-1840 see "ORACLE Error Messages and Codes Manual". (1252)
input value not long enough for date format.
Resolution:
FIND FRIST tableC WHERE tableC.datefield1 = 01/01/95.
IF tableC.datefield1-1 = 1 then do:
...............
Additional info:
SQL to create tableC:
CREATE TABLE tableC
(datefield1 DATE, CONSTRAINT c_pk PRIMARY KEY(datefield1));
Progress Software Technical Support Note # 13811