Consultor Eletrônico

Status: Unverified

FACT(s) (Environment):

Progress 7.x

FACT(s) (Environment):

Progress 8.x

FACT(s) (Environment):

Progress 9.x

SYMPTOM(s):

The numeric formats for this progress-session don't match

Errors that occur due to the inconsistencies that arise when you go backwards in Progress versions (e.g. from Progress 9.x to Progress 8.x) to load data and df.

ERROR
Error during ADD TABLE Invoice
Table: In
Field ** Line 2 AREA Info Area
Index:
Sequence: Unknown TABLE keyword

ERROR
Database: ** Error during ADD FIELD Invoice-Num **
Table:
Field: ** Line 10 POSITION 2
Index:
Sequence: Unknown FIELD keyword

ERROR
Database: ** Error during ADD FIELD Invoice-Num **
Table:
Field: ** Line 10 SQL-WIDTH 4
Index:
Sequence: Unknown FIELD keyword

ERROR 83
The numeric formats of this PROGRESS-session
and the .d-file don't match!
Please exit PROGRESS and start a new session
with the -E startup parameter.

ERROR 147
** The month of a date must be from 1 to 12. (80)

Load of database contents completed.
Errors listed in .e files placed into same directory as .d files

>> ERROR! -d <mdy> or -yy <n> settings of dump were dmy-1950
** but current settings are mdy-1900. May cause load errors.

CAUSE:

The trailer information created in the .d file for by later version of Progress is not expected in the earlier version. Subsequently the earlier version raises errors.

FIX:

The following is a small excerpt from the .df file.
NOTE: The three lines that begin with "AREA", "POSITION" and "SQL"
must be removed throughout the .df file:

ADD TABLE "Invoice"
AREA "Info Area"
DESCRIPTION "This contains transactions for the Receivables system"
DUMP-NAME "invoice"
TABLE-TRIGGER "CREATE" NO-OVERRIDE PROCEDURE "sports/crinv.p" CRC "?
"
TABLE-TRIGGER "DELETE" NO-OVERRIDE PROCEDURE "sports/delinv.p" CRC
"?"

ADD FIELD "Invoice-Num" OF "Invoice" AS integer
FORMAT ">>>>>9"
INITIAL "0"
POSITION 2/