At 10:59 AM 8/12/2004 +0100, Alastair Burr wrote:
Having removed the old default, created the table again and by using single quotes around the default date values ('01/01/1900') everything now appears to be working.
I still don't understand what's happening, however, because I had to put the quotes around the default date values manually after running the create table command - they seem to get stripped out somehow - and without them the default dates are not inserted but with them they are!
Here's the reason why you have to put quotes around the dates:
You could NOT put a date literal in an expression
(like SET VAR v1 DATE = ('01/31/2004' + 1)) without
putting the quotes around the date. This is to let
R:BASE know that you are not putting in a math
expression with 1 divided by 31 divided by 2004.That should help you understand the reason.
Very Best R:egards,
Razzak.
