Thanks, Razzak,
I probably should be a little more careful with my terminology:
I RELOAD all my databases regularly - sometimes daily, usually weekly, at
most monthly - depending on usages.
What I am doing now is re-LOADing from an UNLOADed file - this would last
have been done in early January last year. I do this to rebuild the RB1 and
so check for any errors not picked up in the general maintenance and, year
by year, these get fewer and fewer as you keep improving R:Base and I keep
correcting my mistakes. (This is 4th db I've processed this year and first
to give any hiccup at all.)
For some reason I seem to remember that there used to be a reason for not
using the ((IFNULL(DateColumn,.#DATE,DateColumn))) solution but I'll give it
a try again now.
Regards,
Alastair.
----- Original Message -----
From: "A. Razzak Memon" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Wednesday, January 28, 2009 4:34 PM
Subject: [RBASE-L] - Re: -ERROR- Specified default value is not validfor
column ReleaseDate (2793)
At 10:20 AM 1/28/2009, Alastair Burr wrote:
I'm reloading a table and I guess this is a tightening up that I have
missed.
The column is (not surprisingly) a DATE column and the default is :
(.#DATE)
I've tried un-dotted and without brackets but still get the error.
Stranger, I have two other similar columns, Entry_Date & Up_Date,
one of which
has the same default but the other is computed rather than defaulted and
uses
an Expression with the calculation: (.#DATE). Both these columns follow
the
ReleaseDate in the table so I don't know (yet) if either will fail also.
Any thoughts, anybody?
Alastair,
Just curious ...
When was the last time you did the RELOAD or built a table or entire
database
with a date column having the default value as (.#DATE)?
Try the following approach when using the .#DATE as default.
Example:
((IFNULL(DateColumn,.#DATE,DateColumn)))
This should provide your desired results, even when updating the record
using
the form. This logic is applicable only when a new record is inserted,
which
is similar to the default value.
Cheers!
Very Best R:egards,
Razzak.
--------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.176 / Virus Database: 270.10.15/1921 - Release Date: 28/01/2009
06:37
