Bernie I agree It sounds like a data corruption problem. My only problem with that is I can not find it whatever method I use. I can not even find it in a table with four colums and 41 entries not more than I can inspect line by line. Even if it looks and sounds like a data corrutption problem that I already have cured I am still paranoid about this since I do not understand it, that means I do not know how to prevent it in the future
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Bernie Corrigan Sent: den 11 december 2002 20:37 To: [EMAIL PROTECTED] Subject: RE: Unload all/Reload/ Pack Gunnar - This sounds like you may have some data corruption issues. Try unloading the tables which have zero rows individually and see if they have any data problems. Also: are you getting any error messages when you run the file which recreates the database. Bernie ---------------------------------------- At 08:28 PM 12/11/2002 +0100, you wrote: >Thanks >Sounds very much like what I do. I did say delete but of cource I have a >backup (in fact at least 3 Tape, my own C-drive plus the renamed db on >the network) >But yet I have experienced problem with > output filename.all > unload all > output screen > disconnect > rename db.rb* olddb.rb* > run filename.all >where some of the tables come back with zero entries as compared to >reload where the enries is not gone. >Gunnar > > > > >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] >On Behalf Of Emmitt Dove >Sent: den 11 december 2002 19:34 >To: [EMAIL PROTECTED] >Subject: Re: Unload all/Reload/ Pack > > >Gunnar, > >What we do is: > > output filename.all > unload all > output screen > disconnect > rename db.rb* olddb.rb* > run filename.alll > >The key here is the rename of the database rather than a delete. Only >caveat is that you must be sure that "olddb.rb*" does not exist in the >current directory; otherwise, when you "run filename.all" you'll be >duplicating your data. But this technique leaves the original database >intact in case the process fails somehow. All you have to do then is >rename it back to the original name. > >>Has someone a guidence? >>1. If I do a pack I understand I take a chance on no power breakdown. >>2. If I do a reload I should not have the risk of power breakdown but >>have the same result as 1 obove. >>3. If I do unload all then delete the database base an load it back, >>that should be the same as 2 obove.!? >>4. If 2 and 3 and that does not give the same result what am I doing >>wrong? >>5. I am mostly on DOS 1.862 (or Windows corresponding version) >>Background: >>1. I am doing conversion work from Glorious 2.11 to Dos version of >today >>waiting for the future win 7.0 to go Windows when happy days will >>arrive. >>Other minory ? that I can not answer! >>1. Has someone an Idea where I can look for answers? >>2. Has anyone an Idea what to look out four? >>Not to worry! >>1. Some 20 % of my application is running on 1.862 but I would be happy >>to understand above subject before I Move remaining 80% from 2.11 >> >>??? From the Swedish Dinosaur of 2.11 world ??? >>Gunnar >> > >Emmitt Dove >Manager, DairyPak Business Systems >Blue Ridge Paper Products, Inc. >40 Lindeman Drive >Trumbull, CT 06611 >(203) 673-2231 >[EMAIL PROTECTED] >[EMAIL PROTECTED] > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
