At 07:54 AM 8/13/2004 +0100, Alastair Burr wrote:
I copied & pasted your code, Razzak.
As I was trying to explain before the table is created but the quotes around the default dates are lost when you subsequently look at the entries in the data designer. Yesterday, without those quotes in place, I could not get a default value entered.
Alastair,
If you noticed, in my example of CREATE TABLE ..., I didn't use single quotes around the default dates.
For curiosity's sake - what happens if you design a form based on that table and use ENTER USING FormName. Do you see those defaults in the form?
Very Best R:egards,
Razzak.
P.S. I hope you are using the latest update and/or pre-release version.
----- Original Message -----
From: "A. Razzak Memon" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, August 13, 2004 12:45 AM Subject: [RBG7-L] - Re: Data Designer Default Dates
> 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.
