Tom -
Since your original database was created in an earlier version, I would do a
complete Unload of data and see if that helps. Follow these steps:
At the R> type:
SET MESSAGES ON
SET ERROR MESSAGES ON
SET NULL -0-
OUTPUT filename.str
UNLOAD STR
OUTPUT SCREEN
OUTPUT filename.dta
UNLOAD DATA
OUTPUT SCREEN
This will create three new files:
filename.str
filename.dta
filename.lob
DISCONNECT from the current database.
>From the OBJECT manager, rename the original database to something else.
Before you run this program, you have to split the structure file into two
files in case you have any primary/foreign key designations that are out of
sequence. In a text editor, open the file filename.str, and search for the
word "ALTER". If you do not see the word "ALTER" in your file, then you
haven't used any Primary/Foreign keys so you can close this file and just
continue on.
If you do find the word "ALTER", split this file into two files, breaking
on the first line of the first '"ALTER TABLE" statement - everything BEFORE
this line is saved in file1, everything else from this line forward is saved
in file1. Save the top part of the file as file1.str, and save the bottom
part of the file as file2.str.
Go to the R> and if you still have just one file, type:
RUN filename.str OR even better, type TRACE filename.str and look for
errors as it re-creates your database.
OR if you split the file,
RUN file1.str (or TRACE file1.str)
If you get any error messages review the commands in this file and see if
you can see what's wrong.
Next, type:
RUN filename.dta - this will load back in all your data.
Next, if you split the structure file, type:
RUN file2.str
I know this seems like a lot of steps - but it's not really too bad ...
I've posted a request to the RDCC to create a new UNLOAD syntax that
creates the three files in one but so far it hasn't been implemented ...
At any rate - feel free to contact me privately if you still have problems
with this -
Sami
-----------------------------------------------------------
Sami Aaron
Software Management Specialists
19312 W 63rd Terr
Shawnee KS 66218
913-915-1971
http://www.softwaremgmt.com
----- Original Message -----
From: "Tom Eldred" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
Sent: Wednesday, January 15, 2003 12:23 PM
Subject: [RBASE-L] - Re: hmmm strange happenings
> thanks - tried you thought at R:prompt and got nothing??? what did i do
> wrong :-)
>
> as for the previous build ... I'm not certain.. we upgraded to 6.5++ and
ran
> patch two when it became available.. but god help me if i know what the
> build number is. The original structure was designed in v3.1
>
> thanks
> tom
> ----- Original Message -----
> From: "Sami Aaron" <[EMAIL PROTECTED]>
> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
> Sent: Tuesday, January 14, 2003 1:45 PM
> Subject: [RBASE-L] - Re: hmmm strange happenings
>
>
> > Tom,
> >
> > What version of R:BASE were you using before 1.862?
> >
> > What happens if you do this:
> >
> > 1. OUTPUT structure.txt
> > 2. UNLOAD STR
> > 3. OUTPUT SCREEN
> >
> > Then edit the resulting structure.txt file and look for the "COMMENT"
> > statements - are they the correct comments or are they the strange ones?
> >
> > I have seen some strange corruption in databases that were originally
> > created in 4.0 and earlier that, even after many, many RELOADs, have
> strange
> > things in the structure file.
> >
> > I would run a complete unload of structure and data to rebuild the RB1
> file.
> >
> > Sami
> >
> > -----------------------------------------------------------
> > Sami Aaron
> > Software Management Specialists
> > 19312 W 63rd Terr
> > Shawnee KS 66218
> > 913-915-1971
> > http://www.softwaremgmt.com
> >
> > ----- Original Message -----
> > From: "Tom Eldred" <[EMAIL PROTECTED]>
> > To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
> > Sent: Tuesday, January 14, 2003 11:04 AM
> > Subject: [RBASE-L] - hmmm strange happenings
> >
> >
> > > Good Afternoon everyone...
> > >
> > > I have a recent and unusual development here on my end. We are using
> > 6.55++
> > > 1.862xRT03 on Windows 98 across a Netware 6 network and as of this
> > morning,
> > > all of the descriptions for tables and columns seem to be some what
> > > scrambled.
> > >
> > > There have been no changes to our data structure or other programming,
> but
> > > in the place of the old descriptions are messages such as
> "#COM_ID=65565"
> > ,
> > > "#COM_ID=65572" ... and where that message doesn't appear the
> descriptions
> > > are randomly mismatched.
> > >
> > > I attempted to access the same data from a know to be good back up
> > > (11-19-02) and I see the same results. Is there an issue with the
> in-line
> > > patch 3 and older "legacy" databases or is this a glitch someother
> > way?....
> > >
> > > any assistance would be greatly appreciated
> > >
> > > thanks
> > > tom
> >
> >
>
>
>
