Are using SDT, by any chance? If so, read on...
Disclaimer: SDT is a wonderful product - any problem noted here is the result of old metadata getting restored when it shouldn't have been...
I've seen this when using SDT to repair tables and the structure stored in the metadata tables are not in synch with the structure in the database - in your case, the metadata would have a field in this table whose size is 2 off from what it should be.
The only way I've been able to fix this is to
- restore a backup of the table from before the records were shifted,
- make sure the COREMETA table has the correct structure for the table you are repairing - I would go ahead and check all tables while you're at it,
- and then run the SDT repair again (if you need to repair it)
There may be other ways of fixing this, but I do not know them.
>Hello, All.
>
>I've got a problem. Here it is:
>
>Contents of one of my tables have is changed by shifting with 2 bytes. Example:
>
>Table structure:
>
>pretstoc(n,12,2)
>cantitate(n,10,3)
>denumire(c,30)
>grupa(c,10)
>
>Original record:
>
>10000.00
>234.67
>FAINA....
>ALIMENTAR..
>
>Record shifted:
>100.00
>002.34
>67FAI....
>NAALIMENT..
>
>
>As you see, contents of numeric fields is combined with content of character fields. Can somebody explain this behaviour?
>
>I've spend three days to restore the database. _it_is_NOT_fair!_
Insanity: Doing the same thing over and over and expecting different results.
