Dan, I have done the Unload/Load process several times since this started showing up and not until this morning did I get any error messages. Since I did get one this morning, I will have to do a TRACE to find where the offending table is sometime tonight.
I am not convinced that is the problem. The illegal table name may be the result of RBASE "hanging" because of the I/O problem. Since this is the first time I got an error and since I have rebuilt the DB a few times since this started, I do not think that is the problem. This started around the time I started creating a View for a new parts allocation system. Any time I get into the form more than a couple of times in the DB explorer mode, (without getting out of RBASE completely) the system gives me this error. I would think it has something to do with the views created in the form. This code creates the temp table. CREATE TEMP TABLE topenorder (control# TEXT (9), dateprom DATE, + distname TEXT (25), shipname TEXT (25), shipnotes NOTE) INSERT INTO topenorder SELECT control#, dateprom, distname, shipname, shipnotes FROM orderheader WHERE creditok = 'Y' AND control# IN + (SELECT DISTINCT control# FROM orderpartsneed) This is the form I just created a few months ago when this started. BROWSE USING kpropackview This is the view created on after start EEP. CREATE TEMP VIEW tinvallopen + (partnum, invpcs, alocatepcs, availpcs, madepcs, outpcs, openpcs, vfont) AS SELECT partnum, invpcs, alocatepcs, availpcs, madepcs, outpcs, openpcs, (IFLT(availpcs,0,'RED','BLACK')) + FROM Inv_all_open WHERE Partnum IN (SELECT Partnum FROM OrderPartsNeed WHERE Model# = .vModchoice) It seems rather simple to me and I can't see why it would cause a problem. James Belisle Making Information Systems People Friendly Since 1990 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dan Goldberg Sent: Tuesday, February 14, 2012 8:28 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: I/O problems Have you checked your database for errors? Dan Goldberg -----Original Message----- From: Jim Belisle Sent: Monday, February 13, 2012 7:21 PM To: RBASE-L Mailing List Subject: [RBASE-L] - I/O problems I mentioned this a few weeks ago but still have not been able to find out why I am getting this I/O error. Here is what I have done so far. 1) I looked and found only one rbengine76.CFG file 2) I changed my scratch settings to C:\TEMP form my local settings (C:\Documents and Settings\jim\Local Settings\Temp) and that did not help. 3) I clear my scratch files each time I start a session and that clears them out. Most of those files also clear out when I exit RBASE. The time that I get this error most is when I am in the explorer mode and am testing new forms. Is there anything else someone can point to that may help me figure out why this is happening? James Belisle Making Information Systems People Friendly Since 1990
