There is a simple way to convert the 0:00:00 value to "N.A." in a report on the fly: Define the variables as follows: V_old_time = (CTXT(your_time_col)) V_new_time = (IFEQ(.V_old_time, '0:00:00','N.A.',.V_old_time) ) The variable V_new_time will hold "N.A." if you time column is 0:00:00 if not if will hold the original time, just display V_new_time in your report as a TEXT variable. You can use any text characters instead of "N.A." such as "-" or you can use a blank space(s). IMHO "N.A." or "-" or " "looks better in a report that "-0-" Also, you can define the default value for the column as 0:00:00 so you do not need to enter anything if a time is not available. One caveat, you cannot use 0:00:00 for a valid time as it will displayed as whatever value you select for the null value... the chances are 1 in 86,400 (seconds in one day) Good luck,
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln., Suite #14 Olathe, KS 66062-4571 (913)829-0888 (913)649-2904 FAX -----Original Message----- From: [EMAIL PROTECTED] [mailto:owner-rbase-l@;sonetmail.com]On Behalf Of Claudine Robbins Sent: Wednesday, October 30, 2002 1:34 PM To: [EMAIL PROTECTED] Subject: RE: NULL in Date Field Javier, David, I've tried every combination you have suggested. The 00:00 time is really 12:00 AM, resetting it to NULL resets it to 12:00 AM. Using the IF timefield = 000 THEN;ALTER TABLE...ALTER fieldname = 'N/A' TEXT seems to work, so I'm following that thread right now. However, I have to run to the office and scan for that friendgreeting virus one of my employees let through this morning even though I forwarded the virus alert... ~Claudine :) -----Original Message----- From: [EMAIL PROTECTED] [mailto:owner-rbase-l@;sonetmail.com] On Behalf Of David M. Blocker Sent: Wednesday, October 30, 2002 11:47 AM To: [EMAIL PROTECTED] Subject: Re: NULL in Date Field Claudine Can you run an UPDATE afterwards to set all 00:00 times to NULL? David BLocker ----- Original Message ----- From: "Claudine Robbins" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 30, 2002 11:18 AM Subject: NULL in Date Field > I recently setup a table with times to be picked in a form with a choose > command. That works well. However, sometimes the time is unknown and > requires a blank entry, a NULL (-0-) would be fine but Rbase will allow > nothing but time values in a time field. Even forcing a -0- into the > field doesn't work, Rbase converts it to 00:00 or 12:00 AM depending on > the time format. This time field prints on my report so I can't have > any value when that value is unknown. > > I will now proceed with changing the two time fields in the table to > TEXT in order to circumvent this but I thought I would submit it to the > list first and see if anyone can see around this corner. > > ~Claudine :) > > ================================================ > 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/ ================================================ 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/
