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
