Dan,
It's only a problem if you can tell what is missing and if it is important
to you.
I would not do a reload on a database with errors, I would fix the errors
first, then a reload is a must.
What version of R:Base are you using?
What kind of communication programs do you have? PCAnywhere, NetOp?
What is your internet connection? Modem, cable, DSL?
Do this on your original database:
out autochk.dta with screen
AUTOCHK dbname full
out screen
Then send me the file autochk.dta
Bernie Lis
----- Original Message -----
From: "Dan Champion" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Thursday, September 29, 2005 12:37 AM
Subject: [RBASE-L] - Re: Index Broken?
Bernie,
I did the reload on a backup database just to see if it would help...
won't do it on the real thing till I know what about the lost rows... is
it a problem?
At 01:39 PM 09/28/2005, you wrote:
Hi Dan,
Glad to hear your problem has been solved.
Bernie Lis
P.S.
since you posted on the rbase list, I presume you are still in 6.5 or
lower.
Have you looked into 7.1 or 7.5 yet?
----- Original Message ----- From: "Dan Champion"
<[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Wednesday, September 28, 2005 2:08 PM
Subject: [RBASE-L] - Re: Index Broken?
Thanks Buddy,
The only errors I am seeing is a difference in row counts.... so many
expected, so many found.
So, I did as you suggested and have no errors now with the autocheck.
So the missing rows.... no problem?
Dan
At 01:46 PM 9/28/2005, you wrote:
Dan
The steps I would take would be
1.
Make a backup copy of the database
2.
To see the results of the autochk is to output it to a file.
R:>OUT VHC.chk
R:>autochk VHC FULL
R:>OUT TERM
Use a some text editor to review the file VHC.chk
3.
Reload the database
4.
Run step 2 on the reloaded database and review for any errors.
5.
Depending on the errors (if any) you may need to use R:Scope
Buddy
________________________________
From: [email protected] on behalf of Dan Champion
Sent: Wed 9/28/2005 10:20 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Index Broken?
Bernie,
When I run autochk VHC FULL it scrolls through so much that you
can't possibly read it all. So I don't know how to tell how many
errors. At the bottom it does say Errors have been encountered.
I have tried Rscope years ago, but never had a clue what to do with
it.
The database is over 450 megs, so sending it email anywhere is out.
Hmmmm.... the closest developer to me is..... You... what a hoot.
I am in Grand Rapids MI.
At 10:02 AM 9/28/2005, you wrote:
Another consideration -- is there a developer near you?
Where are you.
On the R:Base site, look for a developer next door to you.
----- Original Message -----
From: Dan Champion <mailto:[EMAIL PROTECTED]>
To: RBASE-L Mailing List <mailto:[email protected]>
Sent: Wednesday, September 28, 2005 9:54 AM
Subject: [RBASE-L] - Re: Index Broken?
Hmmm,
Autchk always finds errors.... Never figured out how
to fix them yet....
At 09:48 AM 9/28/2005, you wrote:
Hi Dan,
Run autochk - if no errors, do a reload.
Bernie Lis
----- Original Message -----
From: Dan Champion
<mailto:[EMAIL PROTECTED]>
To: RBASE-L Mailing List
<mailto:[email protected]>
Sent: Wednesday, September 28, 2005
9:36 AM
Subject: [RBASE-L] - Index Broken?
Hi,
I am thinking I have a broken pointer
or a bad index or something but wanted to quickly pose my problem here
and see if people agree or point me otherwise.
If I ....
choose vold for #values for distinct
buyer , buyer +
from purchase at 10 , 50 Caption "Pick
one" lines 20
then when I
bro all from purchase whe buyer = .
vold
I get no rows exist warning.... However
if I...
bro all from purchase whe buyer cont .
vold
Then sometimes it is there..
What do you think?
Dan Champion
www.championsolutions.net
<http://www.championsolutions.net/>
616-299-7420
Dan Champion
www.championsolutions.net <http://www.championsolutions.net/>
616-299-7420
Dan Champion
www.championsolutions.net
<http://www.championsolutions.net/> 616-299-7420
Dan Champion
www.championsolutions.net
616-299-7420
--- 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.
================================================
