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/
