Hi Alastair I started RBW con to db, (writechk is off by default) unloaded all, the output file is 3 meg.
Set writechk on unload all output file is 300K That's all I did. I had thought it could be a date problem because most of the tables without data have dates but some don't have dates. thanks marc --- Alastair Burr <[EMAIL PROTECTED]> wrote: > Marc, > > Are you still running the part RBASE.CFG before you > run this code? > > If you are maybe there's some difference in the > settings in the "real" > rbase.cfg that get changed by your pre-run one. > > You said before that you thought the dates might be > a cause of the problem. > What I was getting at before in my first response > was that there could be > some difference - not that the settings were wrong. > Are you changing the > "default" config settings on purpose or just trying > to ensure that they are > the default? > > As I understand it, writechk only confirms the > writes to disc and, > presumably, doesn't care less what it writes, just > that it matches what > R:Base tells the system to write. All I can think of > is that, somehow, the > date - if that's the problem - is not being exported > as R:Base expects. > > You could test it by unloading only certain columns, > ie, exclude dates - or > whatever you think might be the problem. If it's not > too many columns you > could exclude one by one <g> - but you might find > the cause that way then > you can try and find out why. > > Good luck, > Regards, > Alastair. > > > ----- Original Message ----- > From: "marc schluter" <[EMAIL PROTECTED]> > To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> > Sent: Monday, August 11, 2003 2:52 PM > 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 > > > > --- RBASE-L > > ================================================ > > TO POST A MESSAGE TO ALL MEMBERS: > > Send a plain text email to [EMAIL PROTECTED] > > > > (Don't use any of these words as your Subject: > > INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, > > REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) > > ================================================ > > TO SEE MESSAGE POSTING GUIDELINES: > > Send a plain text email to [EMAIL PROTECTED] > > In the message SUBJECT, put just one word: INTRO > > ================================================ > > TO UNSUBSCRIBE: > > Send a plain text email to [EMAIL PROTECTED] > > In the message SUBJECT, put just one word: > UNSUBSCRIBE > > ================================================ > > TO SEARCH ARCHIVES: > > Send a plain text email to [EMAIL PROTECTED] > > In the message SUBJECT, put just one word: > SEARCH-n > > (where n is the number of days). In the message > body, > > place any > > text to search for. > > ================================================ > > > __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com
