Hi Sami,
Thanks for the Heads-Up.
The PackVersusReload.pdf is old -- doesn't mention 7.x but I guess it all
still applies.
I just did an Unload All and then reloaded it and got a few errors.
They were all on views that didn't get reloaded.
But I did this on a backup database so I can investigate before doing it for
real.
Bernie
----- Original Message -----
From: "Sami Aaron" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Saturday, April 26, 2008 11:58 AM
Subject: [RBASE-L] - Re: Group by -- need another set of eyes
Bernie -
The RELOAD command just COPIES the existing RB1 file (or RX1 file) to a
new
file, but it does NOT rebuild it. RELOAD does rebuild indices but it does
NOT drop then recreate the index designation on the table.
If you do this:
OUTPUT filename.txt
UNLOAD ALL --or UNLOAD ALL FOR tablename
OUTPUT SCREEN
Then RBEdit the resulting file, filename.txt, and you'll see that there
are
programming commands that effectively recreate the database and/or tables
from scratch using the CREATE TABLE commands along with any CREATE INDEX
commands, and so on. See the file, "Using Enhanced UNLOAD STRUCTURE
Command
in R:BASE" in Razzak's From The Edge site
http://www.razzak.com/fte/pdf/UsingEnhanced_UNLOAD_STRUCTURE_Command.pdf?s
for more info and details.
So Razzak had you drop just the one index and recreate it; but if you're
worried about the entire database, run UNLOAD ALL - read
http://www.razzak.com/fte/pdf/PackVersusReload.PDF for more details.
Sami
____________________________
Sami Aaron
Software Management Specialists
913-915-1971
[EMAIL PROTECTED]
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis
McGrath
Sent: Saturday, April 26, 2008 6:54 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Group by -- need another set of eyes
Bernie,
No. Reload cannot fix inherent errors in underlying definitions like your
index.
UNLOAD/RELOAD actually recreates the database in it's entirety from
scratch.
If no errors are thrown you know your new database is as healthy,
structure
wise, as it can get.
Dennis McGrath
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bernard
Lis
Sent: Friday, April 25, 2008 3:56 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Group by -- need another set of eyes
Dennis,
Maybe. I did a reload into another name, that didn't make any difference.
Isn't that the same as an unload, reload?
Bernie
