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/
