Dave - Responses to two of your three paragraphs - 1. The corruption must have been in your RB1 file and the easiest way to fix that is to do an UNLOAD ALL then load the file back in to re-create the database. Neither RELOAD nor PACK recreate the RB1 file. 3. I'm guessing that when you did the updates at one time you selected a Server Update rather than the standard update. This puts all the R:BASE files into the target folder instead of in the user's Windows folders. Search for RBENGIN*.* and see if they show up in multiple locations with different dates. Sami ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Sami Aaron Software Management Specialists 913-915-1971 [EMAIL PROTECTED]
________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of dgallup Sent: Monday, March 07, 2005 8:08 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Autofix Thanks to David, Dennis, Victor and Razzak for the help and suggestions regarding my corrupted database. In an attempt to determine where the problem lay, I noticed that the TALLY command by date produced two separate tallies for a single date in a lengthy list, an absurd result. So I reintered the dates, I reintered whole rows, I tried everything. The table is a simple table noting transactions in a book business I have. Each row contains a buy or a sell and there are about 15 columns, one of which is the date of transaction. Since 1985, when I first began Rbase use, I have never had a date sort problem; I've had several in the last 3 months. This time was serious and I tried the above named folks' suggestions. I deleted, added, packed, unpacked, reloaded, mixed and scrambled and sauteed. I beat upon the computer and prayed to the Rbase gods. Nothing worked. I then bit the bullet and unloaded the data and reloaded into a newly created empty database. The problem went away. It took a while. Thank you much for the help. I surely do appreciate it and this list is extremely useful - friendly too. I also note that no one ever mentioned AUTOFIX. Is this a taboo subject? Has it vanished forever? And one final question. I updated Rbase with Update 80 but it does not register as Build 30228, but shows the 30209 Build as the current one. Did I do something wrong. I tried loading the new build twice but same result. Dave Gallup, House of Books.
