At 09:38 AM 2/10/2011, Coxen, Dayle wrote:
You are correct. The 6.5++ reload throws the same error.
It must be a very subtle problem with the data. The application
that uses it works fine. Very curious...
Dayle,
You SHOULD be curious, and should lose sleep until you know that
your database is healthy and you don't know of any error(s). <g>
Maintaining the data integrity is among the strengths of R:BASE!
While LOADing the data, values are checked for correct data type,
and an ERROR is thrown for incompatible value(s). The record (row)
with such ERROR is NOT loaded.
In your specific situation, you will need to correct the appropriate
column(s) value(s) in the original database (6.5++) by using a very
simple approach as follows:
01. EDIT * FROM tablename ORDER BY colname
Once the data is displayed, carefully look at the values from
top to bottom for obvious incorrect values.
02. You may also use the "TALLY colname FROM tablename" approach to
view the obvious incorrect values.
Once you have corrected these specific values, use your favorite
approach to UNLOAD DATA, and then LOAD the corrected DATA in 9.1.
You may also take a look at the following articles for more details:
From The Edge: http://www.razzak.com/fte/
Topic: Database Maintenance
Hope that helps!
Very Best R:egards,
Razzak.
