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. > ================================================ >
