Albert, I stepped away and have to leave in a few minutes. Yes that column is indexed.
James Belisle Making Information Systems People Friendly Since 1990 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Albert Berry Sent: Tuesday, February 14, 2012 10:24 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: I/O problems Is the column Model# indexed? Albert On 14/02/2012 8:20 AM, Jim Belisle wrote: > 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)
