[RBASE-L] - Re: Index Broken?

[Dan Champion]

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: rbase-l@rbase.com 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:rbase-l@rbase.com>

                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:rbase-l@rbase.com>
                                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