Dan,
To fix your problem.
1) make a backup copy of your database. Work only on a copy of database until
you evaluate results
2) follow Buddy's instructions as outlined. Analyze the report and make a list
of tables withproblems.
3) Run AUTOFIX.EXE program.
Syntax from www.rsyntax.com
"Name: AUTOFIX Shortest: AUTOFIX
Family: Command Category: Data Integrity
Description: Use AUTOFIX, an external DOS utility, to repair broken
pointers. Pointers, which link rows in a table, can become damaged, and then
R:BASE is unable to find rows in the database.
Syntax
AUTOFIX syntax diagram
Options
dbname
Specifies the name of the database.
tblname
Specifies the table name.
About the AUTOFIX Command
AUTOFIX.EXE is a stand-alone DOS utility included in the installation
directory. Use the AUTOFIX command to fix a database with broken pointers in
tables without columns with NOTE or with LOB data types such as VARCHAR or
VARBIT. If rows will be lost, the number of rows affected is displayed, and the
user is asked whether to continue with the repair.
AUTOFIX uses the calculated row size of a given table and searches the database for
rows which match that size. For this reason tables with rows of variable width, such
as those that contain note columns, or tables with rows that contain pointers to the
Binary file (RB4), such as tables that contain VARBIT or VARCHAR columns, can not be
AUTOFIXed."
If you have tables that cannot be auto fixed. then ypu nee RSCOPE.
Using a database with table problems could eventually result in complete
failure.
--
Jim Bentley
American Celiac Society
266 Midway Dr
River Ridge LA 70123
email: [EMAIL PROTECTED]
Phone: 504-738-6165
-----Original Message-----
From: Dan Champion <[EMAIL PROTECTED]>
Sent: Wed, 28 Sep 2005 14:08:18 -0400
To: [email protected] (RBASE-L Mailing List)
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
