Just in case, if the columns in the view have the same name, it will keep you from reloading correctly. It will give you an error or not load the view.
Gary ----- Original Message ---- From: Bernard Lis <[EMAIL PROTECTED]> To: RBASE-L Mailing List <[email protected]> Sent: Sunday, April 27, 2008 7:29:59 PM Subject: [RBASE-L] - Re: Group by -- need another set of eyes Hi Gary, I doubt it, but I wll certainly check that out. Incidentally, one of the views that didn't reload is a view based on a view, which I see is another topic being discussed. Bernie ----- Original Message ----- From: Gary Wendike To: RBASE-L Mailing List Sent: Sunday, April 27, 2008 6:04 PM Subject: [RBASE-L] - Re: Group by -- need another set of eyes 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 > > >
