That's true, but I was looking for something that was the date equivalent of zero (ie 00/00/0000)
Ben Petersen On 24 Jul 2002, at 17:53, Albert Berry wrote: > Depending on the context, #DATE is convenient in many cases. > > "Ben Petersen" <[EMAIL PROTECTED]> wrote: > > >I decided to work with eqNull off just to develop a habit that is more > >universal. The only disadvantage that I've found is in complex views > >w/ expressions. There, the view definition is littered with "ifnull" > >functions and becomes tedious. > > > >Also; I fill any numeric fields with 0's on insert to eliminate nulls. > >But, I've never figured out how to accomplish the equivalent thing > >with dates... has anyone else? > > > >Ben Petersen > > > > > >On 24 Jul 2002, at 9:13, James (Jim) �Bentley wrote: > > > >> Bill, > >> > >> Well said!! This discussion seems to popup now and then on this > >> forum. �I seem to recall that Microrim put this feature in to > >> accommodate one of its biggest customers. �Perhaps it is time > >> to move this feature into the "undocumented" category and eventually > >> remove it from RBase. �I for one have this set to OFF and try > >> as much as possible to adhere to coding to SQL standards. > >> > >> -- > >> Jim Bentley > >> American Celiac Society > >> [EMAIL PROTECTED] - email > >> (973) 325-8837 voice > >> (973) 669-8808 Fax > >> > >> > >> ---- "Bill Downall" <[EMAIL PROTECTED]> wrote: > >> > Thom, > >> > > >> > If you want to use a "standard", it should be OFF. Then you > >> > conform to > >> > the 3-value logic of the SQL Standard: a null (or unknown) value > >> > cannot > >> > be considered "equal" or "not equal" to any other value, not > >> > even > >> > another null (or unknown) value. It is tested with the operators > >> > "IS > >> > NULL" and "IS NOT NULL." Setting EQNULL ON is for your own > >> > convenience, if you have a hard time figuring out how to design > >> > your > >> > database and code you applications within that standard. � > >> > > >> > Bill > >> > > >> > On Mon, 22 Jul 2002 22:27:11 -0400, Thomas J Cimicato wrote: > >> > > >> > >What is the prevailing thought on the use of the EQNULL setting?? > >> > >Should you code for it ON or OFF as a standard? (Off seems > >> > to be > >> > the > >> > >default in the rbase.cfg file. ) > >> > > >> > > >> > > >> > > >> > > >> > ================================================ > >> > TO SEE MESSAGE POSTING GUIDELINES: > >> > Send a plain text email to [EMAIL PROTECTED] > >> > In the message body, put just two words: INTRO rbase-l > >> > ================================================ > >> > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > >> > In the message body, put just two words: UNSUBSCRIBE rbase-l > >> > ================================================ > >> > TO SEARCH ARCHIVES: > >> > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > >> > � > >> ================================================ > >> TO SEE MESSAGE POSTING GUIDELINES: > >> Send a plain text email to [EMAIL PROTECTED] > >> In the message body, put just two words: INTRO rbase-l > >> ================================================ > >> TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > >> In the message body, put just two words: UNSUBSCRIBE rbase-l > >> ================================================ > >> TO SEARCH ARCHIVES: > >> http://www.mail-archive.com/rbase-l%40sonetmail.com/ > >> > > > > > >================================================ > >TO SEE MESSAGE POSTING GUIDELINES: > >Send a plain text email to [EMAIL PROTECTED] > >In the message body, put just two words: INTRO rbase-l > >================================================ > >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > >In the message body, put just two words: UNSUBSCRIBE rbase-l > >================================================ > >TO SEARCH ARCHIVES: > >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > > > > __________________________________________________________________ > Your favorite stores, helpful shopping tools and great gift ideas. Experience the >convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ > > Get your own FREE, personal Netscape Mail account today at >http://webmail.netscape.com/ > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
