[RBASE-L] - Re: Index Broken?

Wed, 28 Sep 2005 18:39:01 -0700 

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


























					Reply via email to