Berni, do the views have multiple columns with the same name? Gary
----- Original Message ---- From: Bernard Lis <[EMAIL PROTECTED]> To: RBASE-L Mailing List <[email protected]> Sent: Saturday, April 26, 2008 4:00:46 PM Subject: [RBASE-L] - Re: Group by -- need another set of eyes 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 > > >
