Bernie, When you have views of views you have to be sure that you maintain the proper create order for the sequence of views.
Thus if you have say 3 views sequence v1, v2, v3. All things equal RBase would unload them in proper sequence. However if you were to Delete and re-create v2 the sequence would now be v1, v3, v2 and Rbase would unload them in that order. This would then cause v3 to fail when reloaded. Jim Bentley --- Bernard Lis <[EMAIL PROTECTED]> wrote: > 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 > > > > > > > > > > > Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293 ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
