Try the following code to create a new table and
see what you get:
-- start
SET ERROR MESSAGE 2038 OFF
DROP TAB ToTeachADB
CREATE TABLE `ToTeachADB` +
(`ReleaseDate` DATE DEFAULT 01/01/1900 NOT NULL +
('Value for column ReleaseDate cannot be null'), +
`Entry_Date` DATE DEFAULT 01/01/1900 NOT NULL +
('Value for column Entry_Date cannot be null'), +
`Up_Date`=(IFNULL(Up_Date,.#DATE,Up_Date)) DATE)
SET ERROR MESSAGE 2038 ON
RETURN
-- end
I used the exact same default values as well as
the expression using Database Designer without
any problem!
Very Best R:egards,
Razzak.
At 11:43 PM 8/12/2004 +0100, Alastair Burr wrote:
Thanks, Razzak, that makes sense. However, it seems R:Base
will not accept quotes around a date value unless they are
put in manually.
Part of my Create Table command was:
`ReleaseDate` DATE DEFAULT '01/01/1900' NOT NULL +
('Value for column ReleaseDate cannot be null') , +
`Entry_Date` DATE DEFAULT '01/01/1900' NOT NULL +
('Value for Entry_Date cannot be null.') , +
`Up_Date`= (IFNULL(Up_Date, .#DATE, Up_Date)) DATE , +
but the quotes around the default value seem to get lost.
There does not seem to be a need to put default text in
quotes. Is that right or is that luck and quotes really
ought to be used ?
----- Original Message -----
From: "A. Razzak Memon" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[EMAIL PROTECTED]>
Sent: Thursday, August 12, 2004 10:38 PM
Subject: [RBG7-L] - Re: Data Designer Default Dates
>
> 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.
>
