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!
--
