Bernie, you do need to ensure that any variable used in a view is defined
before the load as well as having the sequence correct where view(s) are
based on view(s).
Regards,
Alastair.
----- Original Message -----
From: "Bernard Lis" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Monday, April 28, 2008 2:20 AM
Subject: [RBASE-L] - Re: Group by -- need another set of eyes
Thanks Jim,
After the reload was complete, I noticed that v1 did load so then I tried
to load v2 by itself and it still failed.
It said something about a missing global variable.
I will check to determine what that var is as soon as I can muster some
time.
Unlike others on this list, I hate views! I prefer temp tables instead.
Bernie
----- Original Message -----
From: "James Bentley" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Sunday, April 27, 2008 9:03 PM
Subject: [RBASE-L] - Re: Group by -- need another set of eyes
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
--
No virus found in this incoming message.
Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.5/1399 - Release
Date: 26/04/2008 14:17
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
