Happy New Year,
I hope someone can help me with a problem I am am having with Roundtable
V9.0A.
We have recently installed this version of Roundtable on a UNIX server
and are connecting to it using Windows 95 clients.
We have a live system which has been established for a couple of years.
It is currently running Progress V9.0B.
I am having problems loading a skeleton version of the live database
into Roundtable without the CRC's being affected. Ideally, I do not want
to have to modify the live schema in any way.
The first problem I had was the "Load Schema" loaded each table,
re-sequencing the fields into alphabetical order (reflected by the
setting of "rtb_field.field-id").
This caused virtually all CRC's to be incorrect. This was corrected by
modifying the"field-id" in "rtb_field" and "rtb_idxfld" to be sequenced
in the same way as the original database. This worked perfectly.
However, about 10 tables still had CRC mismatches. When dumping the
".df" for each of the tables the only difference is the value of the
"POSITION" entry (This is apparently new in version 9 and I have yet to
see any documentation on it). Roundtable generates the POSITION number
in sequence for each field, but the original database had different
values. Some numbers were skipped and therefore causing a mismatch
between the 2 .df files and hence different CRCs.
If anyone can help me I would be most grateful.
Regards,
Andy Nixon
Senior Analyst Programmer
Specsavers Retail Systems
Eastleigh
Hampshire
UK
I hope someone can help me with a problem I am am having with Roundtable
V9.0A.
We have recently installed this version of Roundtable on a UNIX server
and are connecting to it using Windows 95 clients.
We have a live system which has been established for a couple of years.
It is currently running Progress V9.0B.
I am having problems loading a skeleton version of the live database
into Roundtable without the CRC's being affected. Ideally, I do not want
to have to modify the live schema in any way.
The first problem I had was the "Load Schema" loaded each table,
re-sequencing the fields into alphabetical order (reflected by the
setting of "rtb_field.field-id").
This caused virtually all CRC's to be incorrect. This was corrected by
modifying the"field-id" in "rtb_field" and "rtb_idxfld" to be sequenced
in the same way as the original database. This worked perfectly.
However, about 10 tables still had CRC mismatches. When dumping the
".df" for each of the tables the only difference is the value of the
"POSITION" entry (This is apparently new in version 9 and I have yet to
see any documentation on it). Roundtable generates the POSITION number
in sequence for each field, but the original database had different
values. Some numbers were skipped and therefore causing a mismatch
between the 2 .df files and hence different CRCs.
If anyone can help me I would be most grateful.
Regards,
Andy Nixon
Senior Analyst Programmer
Specsavers Retail Systems
Eastleigh
Hampshire
UK