One more thing I can think of is to check your LAYOUT setting. Try turning it off if it is on.
Troy Sosamon ===== Original Message from [EMAIL PROTECTED] at 9/18/02 2:38 pm >Emmitt, > >I had similar problems but just in the browser on a large table (rows & >columns) - no second db - when I first changed to RBWin which disappeared as >mysteriously as it had begun. > >The only reason that I could find was that there must have been some form of >corruption which somehow got worked out with either RELOAD or BACKUP & >RESTORE. > >I suggest that you try RELOADing both DBs first then back them up to files >and restore if that hasn't solved it. If you backup you can also try >searching the backup file before restoring it for funny characters. I know >it's a slim chance but it does sometimes work if you just look for a change >in pattern rather than anything specific. > >Hope this helps, >Regards, >Alastair. > > > >----- Original Message ----- >From: "Emmitt Dove" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Wednesday, September 18, 2002 7:45 PM >Subject: I/O Problems on SCONNECTed database > > >> >> I have two databases; for the sake of anonymity we'll call them A and B. >> >> A is the working database. B holds history and audits. >> >> A table 'audits' in B is SATTACHed to A. >> >> I have performed an unload/input on B. B passes all tests in R:Scope and >> AUTOCHK. >> >> If I do EDIT ALL FROM audits while connected to A and SCONNECTed to B, and >> then do [ctrl] [end] twice to go to the bottom of the table, I get "I/O >> error - check for a full disk." If I do "EDIT ALL FROM audits WHERE >> auddttm >= 091802" I get the same error. There are exactly two rows that >> meet the specification and they are the last two in the table. The field >> auddttm is not indexed. It is a datetime field. >> >> The table contains 106250 rows. >> >> Peforming the same actions on a table in B with only 28,643 rows works >fine. >> >> The same actions while CONNECTed to B work fine. >> >> My TEMP directory is defined and scratch is set to write there; the disk >> containing that directory has 2.7 gb free. >> >> I get the same result using the R:Base ODBC driver and Oterro 2.5 >1.850xRT03. >> >> I get the same result using R:Base version 6.5++ 1.855xRT03 and 6.5++ >> 1.858xRT03. >> >> Any clues? >> >> >> Emmitt Dove >> Manager, DairyPak Business Systems >> Blue Ridge Paper Products, Inc. >> 40 Lindeman Drive >> Trumbull, CT 06611 >> (203) 673-2231 >> [EMAIL PROTECTED] >> [EMAIL PROTECTED] >> >> ================================================ >> TO SEE MESSAGE POSTING GUIDELINES: >> Send a plain text email to [EMAIL PROTECTED] >> In the message body, put just two words: INTRO rbase-l >> ================================================ >> TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >> In the message body, put just two words: UNSUBSCRIBE rbase-l >> ================================================ >> TO SEARCH ARCHIVES: >> http://www.mail-archive.com/rbase-l%40sonetmail.com/ > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
