Alastair,
Without looking at your specific database, it is very difficult to
tell what is wrong with your database or what else is going on.
I can only help you by providing similar examples and scenarios with
ConComp and/or RRRBYW - RRBYW9 sample databases and applications.
Having said that, try the following test using ConComp:
01. EDIT ALL FROM AllColumns
02. Press [F2] key to insert a new row
03. Type some number in CInteger column and then press [Enter] key
04. While still at the CInteger column, press [End] key to go to
the last column on that newly inserted row
Do you see the current DATE in CComputedColumn?
Notes:
01. CComputedColumn in AllColumns is defined as the following:
Column Name: CComputedColumn
Data Type: DATE
Compute Radio Button: Checked
Expression: (IFNULL(CComputedDate,.#DATE,CComputedDate))
02. CHARacter SETtings:
DELIMIT ,
LINEEND ^
SEMI ;
QUOTES '
PLUS +
SINGLE _
MANY %
IDQUOTES `
03. DATE Settings:
DATE format MM/DD/YYYY
DATE sequence MMDDYY
Century threshold YEAR is 30
Default CENTURY is 19
04. NULL Setting:
NULL symbol -0-
05. EQNULL Setting:
(EQNULL) OFF Treat null EQual NULL as a match
Hope that gives you some insight!
Very Best R:egards,
Razzak.
At 06:51 PM 8/11/2004 +0100, Alastair Burr wrote:
Thanks for your reply, Razzak - the answer is "yes" - that works fine.
I copied and pasted your commands at the R:> and the row is inserted and
today's date entered in the last field as we'd both expect.
However, what I was doing before was opening the table in the Database
Explorer, pressing [F4] and then [F2]. In this case IN MY TABLE NOT ComComp
the calc field was null and I couldn't save the row on exit. If I do this IN
ConComp the date field is null until it is updated as the row is exited.
That leads me to assume that something else is wrong in my table so I come
back to the other point that I made in my original post on this subject:
"In trying to work out why this is not working I have also noticed that two
other date fields are not accepting their default values either. Both are
date fields with the No Calculation radio button selected and a default
value of: 01/01/1900 (date formats: dd/mm/yyyy & ddmmyyyy).
I have tried putting single quotes around the date value which appears to
insert the current date rather than the required date and I have also tried
putting the value in a CTXT function which isn't accepted but, otherwise,
all I seem able to get is a null value."
I've also tried putting the date in brackets but I still get nulls. What is
the correct way to specify the date? On its own? In quotes?
Also, if the Not Null option is checked could that be taking some sort of
precedence?
----- Original Message -----
From: "A. Razzak Memon" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[EMAIL PROTECTED]>
Sent: Wednesday, August 11, 2004 1:14 PM
Subject: [RBG7-L] - Re: Data Designer Default Dates
> 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.
>
