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)
