David,
Please don't be confused. There is enough confusion already <g>.
Follow the example below "-- start ... -- end" and see what you find. Use the same logic/parameters in RBDEFINE to further understand.
Very Best R:egards,
Razzak.
At 10:28 AM 8/13/2004 -0400, David Blocker wrote:
Now I'm confused Razzak. Are you saying you DON'T need the quotes in the database designer screen or do?
David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "A. Razzak Memon" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, August 12, 2004 7:45 PM 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.
