Thanks for trying It must be something about my db.
marc --- William Cook <[EMAIL PROTECTED]> wrote: > I did. I ran, twice, the three snippets of code that > you supplied. > Once with CLEAR ON and then with CLEAR OFF. > > Each output file was the same size. That is: 1.dat, > 2.dat, and 3.dat > all had the same length whether CLEAR was ON or OFF. > > ----- Original Message ----- > From: "marc schluter" <[EMAIL PROTECTED]> > To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> > Sent: Monday, August 11, 2003 12:23 PM > Subject: [RBASE-L] - Re: Unload & pack in 1.866 lost > rows -Razzak's > Reply > > > > Hi Bill > > > > Could you try writechk on for me? > > I am sure it is something to do with my db but I > > haven't got a clue what to look for. > > > > thanks marc > > > > > > --- William Cook <[EMAIL PROTECTED]> wrote: > > > Marc, > > > > > > I am using RBdos 1.866 > > > > > > I ran your code on my database, rb2 file just > over 3 > > > megs. I ran it > > > twice, once with CLEAR ON and once with CLEAR > OFF. > > > > > > My resulting files DAT were all the same length. > > > > > > Bill Cook > > > Kent WA USA > > > > > > ----- Original Message ----- > > > From: "marc schluter" <[EMAIL PROTECTED]> > > > To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> > > > Sent: Monday, August 11, 2003 6:52 AM > > > Subject: [RBASE-L] - Re: Unload & pack in 1.866 > lost > > > rows -Razzak's > > > Reply > > > > > > > > > > I have tested the following several times this > > > weekend > > > > and I keep loosing rows of data with writechk > on. > > > > > > > > set writechk off > > > > out 1.dat > > > > unload all > > > > out screen > > > > > > > > set writechk on > > > > out 2.dat > > > > unload all > > > > out screen > > > > > > > > set writechk off > > > > out 3.dat > > > > unload all > > > > out screen > > > > > > > > File 1.dat and 3.dat are the same size, file > 2.dat > > > is > > > > 10 times smaller. > > > > > > > > What should I look for and why would writechk > make > > > a > > > > difference in the output file? > > > > > > > > thanks > > > > marc > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > --- "A. Razzak Memon" <[EMAIL PROTECTED]> > wrote: > > > > > > > > > > > > At 07:10 AM 8/8/2003 -0700, Marc Schluter > > > wrote: > > > > > > > > > > > > >well folks > > > > > > > > > > > > > >I think I found my problem. > > > > > > > > > > > > > >If I start RBW then do Unload all, > everything > > > is > > > > > > OK. > > > > > > >Then I run > > > > > > > SET ZERO ON > > > > > > > SET WRITECHK ON > > > > > > > SET CLEAR ON > > > > > > >and the output file is smaller and I > loose > > > the > > > > > > rows. > > > > > > >Then I set writechk off and did another > > > unload > > > > > all > > > > > > and > > > > > > >it worked fine. > > > > > > > > > > > > > >It seems that writechk on will not allow > all > > > of > > > > > the > > > > > > >rows to be written to the output file and > it > > > > > > appears > > > > > > >to be the tables with dates. > > > > > > > > > > > > > >Am I crazy or is this possible? > > > > > > > > > > > > > > > > > > Marc, > > > > > > > > > > > > SET WRITECHK ON specifies R:BASE to verify > > > "EVERY" > > > > > > write to disk. > > > > > > > > > > > > So, you may need to check integrity of > your > > > > > database > > > > > > using R:SCOPE. > > > > > > > > > > > > Just for fun: > > > > > > > > > > > > Try the same scenario using the CONCOMP > > > database > > > > > > bundled with the latest R:BASE 6.5++ for > > > Windows, > > > > > > i.e., C:\RBTI\RBWIN65\SAMPLES\CONCOMP and > see > > > what > > > > > > happens. > > > > > > > > > > > > Have Fun! > > > > > > > > > > > > Very Best R:egards, > > > > > > > > > > > > Razzak. > > > > > > > > > > > > > > > > > > > > > __________________________________ > > > > > Do you Yahoo!? > > > > > Yahoo! SiteBuilder - Free, easy-to-use web > site > > > > > design software > > > > > http://sitebuilder.yahoo.com > > > > > > > > > > > > > > > > > __________________________________ > > > > Do you Yahoo!? > > > > Yahoo! SiteBuilder - Free, easy-to-use web > site > > > design software > > > > http://sitebuilder.yahoo.com > > > > > > > > > > > > > __________________________________ > > Do you Yahoo!? > > Yahoo! SiteBuilder - Free, easy-to-use web site > design software > > http://sitebuilder.yahoo.com > > > __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com
