Jim -
RELOAD is not the equivalent of UNLOAD ALL
followed by running the file that the unload was
directed into to rebuild the db. For some reason,
and I don't know why, RELOAD will preserve some
instances of corrupt data through the reload
process. I have never found that corrupt data
can survive the UNLOAD ALL and rebuild process.
Bernie
At 08:12 AM 5/28/2004 -0400, you wrote:
>Rob
>
>We are entering data using a tiered region as well.. for the items.
>I issued a reload statement and then an autochk and then deleted
>tables and ran autochk again and errors were gone. I have to admit
>I don't know the differences in what happens behind the scenes when
>commands like RELOAD, UNLOAD SCHEMA, UNLOAD DATA
>and such. I figured RELOAD would be equivelant to UNLOADing
>SCHEMA and then DATA and then LOADing them.
>
>I did not recreate the tables, because as far as I know they were for
>some kind of temporary reporting most likely.
>
>Jim
>
>Rob Vincent wrote:
>
>>Hey Jim,
>>
>>I experienced this type of problem data-entry problem
>>on a form with tiered regions in RB65++ Win (1.842)
>>
>>The problem did not appear to be related to the database
>>engine but corruption in the database files themselves.
>>
>>I resolved with the following procedure:
>>- UNLOAD data from affected table to a file.
>>- DROP the table from the DB schema.
>>- Re-create table.
>>- LOAD data from exported file back into table.
>>
>>Usually the data will export fine, and it is just the definition
>>that is causing the error.
>>
>>
>>
>>
>
>--- RBASE-L
>================================================
>TO POST A MESSAGE TO ALL MEMBERS:
>Send a plain text email to [EMAIL PROTECTED]
>
>(Don't use any of these words as your Subject:
>INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
>REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
>================================================
>TO SEE MESSAGE POSTING GUIDELINES:
>Send a plain text email to [EMAIL PROTECTED]
>In the message SUBJECT, put just one word: INTRO
>================================================
>TO UNSUBSCRIBE:
>Send a plain text email to [EMAIL PROTECTED]
>In the message SUBJECT, put just one word: UNSUBSCRIBE
>================================================
>TO SEARCH ARCHIVES:
>Send a plain text email to [EMAIL PROTECTED]
>In the message SUBJECT, put just one word: SEARCH-n
>(where n is the number of days). In the message body,
>place any
>text to search for.
>================================================
>
>
