Load Schema Problems

Chris Kelleher

Administrator
Staff member
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
 

Chris Kelleher

Administrator
Staff member
I have a similar setup here. What I do is this:

I setup a Windows NT database using a df created from my UNIX database. I
compile my code in Roundtable against this database. When I am sending code
to the UNIX server, I send the uncompiled code to UNIX and recompile it
there.

Use roundtable to verify the compile of your code, keep track of version
changes, xref, etc. But when it comes to compiling code in your production
environment, it is best to compile it on your production server. Good l
 
Top