Boy oh boy I'll never do THAT again. Do NOT create FKEYS on TEMP tables.
Tried it with both PROJECT <permanent> and CREATE TABLE <permanent> and both worked. Thanks Razzak and Dennis for the Lesson of the Day Bruce -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Wednesday, July 03, 2013 12:47 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Error 2801: Reference table does not exist At 03:23 PM 7/3/2013, Bruce A. Chitiea wrote: >Error 2801: >1. In Designer; >2. After Pack/Reload >3. After Disconnect/Shutdown/Restart >4. In Designer again >5. Replace the PROJECT command with CREATE TEMPORARY TABLE for >TransTest > >******************** >Here's the UNLOADed structure of the referenced table: > >CREATE TABLE `glCode` + >(`glCodeID` INTEGER NOT NULL , + > `glCodeParent` TEXT (4) , + > `glCode` TEXT (4) NOT NULL , + > `glDesc` TEXT (20) , + > `glSort` INTEGER ) > >ALTER TABLE `glCode` ADD PRIMARY KEY (`glCodeID` ) AUTONUM `glCodeID` >IN `glCode` USING 10041. 1. NONUM > >******************** >... and the UNLOADED structure of the FKEY-host-to-be table: > >CREATE TEMPORARY TABLE `TransTest2` + >(`transid` INTEGER NOT NULL + >('Value for transid cannot be null.') , + > `transdate` DATE , + > `glCode` TEXT (4) , + > `transcode` TEXT (1) , + > `transtype` TEXT (3) , + > `transnum` TEXT (12) , + > `vendorid` INTEGER , + > `transmemo` TEXT (40) , + > `ExpAmt` CURRENCY , + > `IncAmt` CURRENCY , + > `glCodeID` INTEGER ) > >ALTER TABLE `TransTest2` ADD PRIMARY KEY (`transid` ) > >******************** >If there's something to see, I'm just not seeing it. Thoughts? Bruce, Just for my curiosity ... Change the TransTest2 table to a permanent one and see what you find. -- Example SET ERROR MESSAGE 2038 OFF DROP TABLE TransTest2 SET ERROR MESSAGE 2038 ON Then ... Use CREATE or PROJECT TABLE command to define TransTest2 table Follow the next steps and see what happens. Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase -- 30+ years of continuous innovation! 15 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
