Alastair,
Does the column expression defined in "ConComp" database (as mentioned below) work on your end?
CONNECT ConComp INSERT INTO AllColumns (CInteger) VALUES (1234) BROWSE * FROM AllColumns WHERE COUNT = INSERT
What do you see in CComputeDate column?
Very Best R:egards,
Razzak.
At 07:45 AM 8/11/2004 +0100, Alastair Burr wrote:
Thanks, David, but it's not the DEFAULT that I'm trying to get to work. This is copied from Razzak's post a while back:
Alastair,
MY emphasis was on DEFAULT values.
"The default values that are expressions are NEVER supported in R:BASE."
You should have no problem when defining values as "Compute" with correct "Expression" as demonstrated in RBG7 sample ConComp Database.
Database: ConComp Table: AllColumns Column: CComputedDate Type: DATE Compute : Checked Expression: (IFNULL(CComputedDate,.#DATE,CComputedDate))
Very Best R:egards,
Razzak
I'm trying to use this expression:
(IFNULL(Up_Date, .#DATE, Up_Date))
which, to me looks the same except for the column names. The data designer accepts the expression and saves it but nay new row added does NOT get the value inserted.
