Marc, I don't know if it will cause any problems but your date sequence contains only 2 characters for the year and the format contains all 4.
As the format tries to display what's in the sequence you may not be seeing everything. The only other thing that might be causing a problem is that your NULL statement is near the end and not at the start when begin to define the pairs of settings. If you have some weird null to start with - unlikely, but not impossible - then you might be getting some odd effect. Regards, Alastair. ----- Original Message ----- From: "marc schluter" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, August 07, 2003 8:33 PM Subject: [RBASE-L] - Re: Unload & pack in 1.866 lost rows > Thanks all for the help > > I think I found my problem. I was running a settings > cmd file before the unload all. I think this caused > some tables and rows to go bye bbye! I guess I was > too smart for my own good. > > Below is the file I war running, I don't see anything > wrong but it seems to be the problem. > > thanks marc > > > SET QUOTES=NULL > SET QUOTES=' > SET DELIMIT=NULL > SET DELIMIT=',' > SET LINEEND=NULL > SET LINEEND='^' > SET SEMI=NULL > SET SEMI=';' > SET PLUS=NULL > SET PLUS='+' > SET SINGLE=NULL > SET SINGLE='_' > SET MANY=NULL > SET MANY='%' > SET IDQUOTES=NULL > SET IDQUOTES='`' > SET CURRENCY '$' PREF 2 B > SET CASE OFF > SET AUTOSKIP OFF > SET REVERSE ON > SET BELL OFF > SET NULL '-0- ' > SET DATE FORMAT 'mm/dd/yyyy' > SET TIME FORMAT 'HH:MM AP' > SET DATE SEQUENCE mmddyy > SET TIME SEQUENCE hhmmss > SET DATE YEAR 5 > SET DATE CENTURY 19 > SET TOLERANCE 0. > SET ZERO ON > SET WRITECHK ON > SET CLEAR ON > > > > > > --- "A. Razzak Memon" <[EMAIL PROTECTED]> wrote: > > At 06:42 AM 8/7/2003 -0700, Marc Schluter wrote: > > > > >Hi all > > > > > >I am using RBW 1.866 and noticed if I Pack all or > > >unload all then load the file, some rows are > > missing. > > > > > >Is this the latest patch? > > >I can't use trace because the unload file is too > > big. > > >How can I figure out what is going wrong? > > > > Marc, > > > > First, you need to figure out why those rows are > > missing? > > > > Bad Index, Broken Pointers, etc ... > > > > After you PACK and/or RELOAD, and if you PACK and/or > > RELOAD > > the PACKed/RELOADed database again, do you still > > miss any > > row(s)? > > > > Take a look at the following article on: > > > > From The Edge: Finding and Fixing Broken Indexes > > (04/30/2002) > > > > http://www.razzak.com/fte > > > > Hope that helps! > > > > Very Best R:egards, > > > > Razzak. > > > > > __________________________________ > Do you Yahoo!? > Yahoo! SiteBuilder - Free, easy-to-use web site design software > http://sitebuilder.yahoo.com >
