catch.saravana
Member
Hi All,
I am receiving the below error while loading the DF file in OE 11.6 but not receiving the error in 9.1E. I have just kept the dummy field/table names - sorry for that. I understood the error for one field but couldn't find for another.
Error:
------
Table: t1
Field: f1
Index: lqqqqqqqqqqqqqqqqq Error qqqqqqqqqqqqqqqqqk
Sequence: ** Error during ADD FIELD f1 **
Invalid Initial value
Table: t2
Field: f2
Index: lqqqqqqqqqqqqqqqqqq Error qqqqqqqqqqqqqqqqqqqk
Sequence: x ** Error during ADD FIELD f2 **
Invalid Initial value
DF:
---
ADD FIELD "f1" OF "t1" AS decimal
FORMAT ">>>,>>>,>>9.99"
INITIAL "999,999,999.99"
LABEL "Label1"
POSITION 14
SQL-WIDTH 240
EXTENT 8
DECIMALS 2
ORDER 110
ADD FIELD "f2" OF "t2" AS date
FORMAT "99/99/9999"
INITIAL "terminal-date"
LABEL "Label2"
POSITION 25
SQL-WIDTH 4
HELP "Enter the date of the order."
ORDER 250
The initial value "terminal-date" is not a date datatype which is the reason for issue but not sure about the first field. Please advise. Thanks in advance.
Regards,
Saravanakumar B
I am receiving the below error while loading the DF file in OE 11.6 but not receiving the error in 9.1E. I have just kept the dummy field/table names - sorry for that. I understood the error for one field but couldn't find for another.
Error:
------
Table: t1
Field: f1
Index: lqqqqqqqqqqqqqqqqq Error qqqqqqqqqqqqqqqqqk
Sequence: ** Error during ADD FIELD f1 **
Invalid Initial value
Table: t2
Field: f2
Index: lqqqqqqqqqqqqqqqqqq Error qqqqqqqqqqqqqqqqqqqk
Sequence: x ** Error during ADD FIELD f2 **
Invalid Initial value
DF:
---
ADD FIELD "f1" OF "t1" AS decimal
FORMAT ">>>,>>>,>>9.99"
INITIAL "999,999,999.99"
LABEL "Label1"
POSITION 14
SQL-WIDTH 240
EXTENT 8
DECIMALS 2
ORDER 110
ADD FIELD "f2" OF "t2" AS date
FORMAT "99/99/9999"
INITIAL "terminal-date"
LABEL "Label2"
POSITION 25
SQL-WIDTH 4
HELP "Enter the date of the order."
ORDER 250
The initial value "terminal-date" is not a date datatype which is the reason for issue but not sure about the first field. Please advise. Thanks in advance.
Regards,
Saravanakumar B