Same .df-file, but different CRC.

[storzi]

Hi,

I have a problem concerning the CRC on a table.
I generate a .df-file which I import in two databases, but
after the import they have different CRC-values.

I import the .df-files with the tool "sy-schema.w".

The fields in this tables are absolute equal but the .r-files works
only for the database that was connected in the AppBuilder during
compilation.

Anyone know what this can be?

 

[StefGay]

Hi, for this table you have certianly add a field in the past, add another and deleted the first onf afterall.
In this case in the .df you have only the add field and no reference of the deleted field.
The CRC take in account the fields _field._field-rpos and in this case the value is different beetween your "production db" and your "devel db".
The workaround i use is to create 2 or more df, the first with the field added and the others includind the "delete field".

Excuse me for my poor english and feel free to contact me if my explanation is confused.

Stéphane.

Hi,

I have a problem concerning the CRC on a table.
I generate a .df-file which I import in two databases, but
after the import they have different CRC-values.

I import the .df-files with the tool "sy-schema.w".

The fields in this tables are absolute equal but the .r-files works
only for the database that was connected in the AppBuilder during
compilation.

Anyone know what this can be?

 

[storzi]

Thanks.
Our Problem have had another cause:

In the .df-file there was a integer-field with decimals(!?):

ADD FIELD "number" OF "Tabelle1" AS integer 
  FORMAT "9999999"
  INITIAL "0"
  LABEL "Nummer"
  POSITION 4
  SQL-WIDTH 17
  DECIMALS 4
  ORDER 30

We have import this .df-file.
Later we have export the .df-file from this table and the decimals-expression was removed from the .df-file.
Now, when we import the .df-file without the decimal-expression we get a different CRC.