At 01:03 PM 5/24/2010, Alastair Burr wrote:
I have a table that I UNLOAD/LOAD in v7.6 that refuses to co-operate in v9.0.
It looks as if the structure in v9.0 will not accept a computed column based
on a previously computed column???
For example, very simply:
(ColA INT, ColB = (ColA * 10) INT, ColC = (ColB + 1) INT)
My calculations are far more complicated than that but by constructing and
testing adding column by column my equivalent of ColC is where it fails.
Is this expected now or am I just missing something obvious?
Alastair,
Using your scenario above, try the test below, and see what you get:
-- Create_Table_With_Computed_Columns.RMD
-- R:BASE eXtreme 9.0 (32/64)
-- Test for Alastair Burr
-- A. Razzak Memon
-- May 24, 2010
SET ERROR MESSAGE 2038 OFF
DROP TABLE tTest
SET ERROR MESSAGE 2038 ON
CREATE TABLE `tTest` +
(`ColA` INTEGER, +
`ColB`= (ColA*10) INTEGER, +
`ColC`= (ColB+1) INTEGER)
COMMENT ON TABLE `tTest` IS 'Test Table'
RETURN
Hope that provide you with some blue's clues ...
Very Best R:egards,
Razzak.
