Thanks - I hadn't thought about that! And it works PERFECTLY!!! Thanks again Fred! -K-
-----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Fred Taylor Sent: Friday, October 05, 2012 5:42 PM To: [email protected] Subject: Re: Logical Data and a Conundrum If the field doesn't support nulls, you can use ISBLANK(fieldname). Returns true if there is no value set, false if a value is set. Fred On Fri, Oct 5, 2012 at 2:10 PM, Kurt Wendt <[email protected]> wrote: > I have this small pop-up window on a screen - that was a custom change > required by a client. They now wanted more changes - including this deal > where there is a Yes/No regarding a Date Field being Required. The > Conundrum is that they want one of them to Default to a Yes. Now, in the > DBF - for the Yes/No fields I am using a Logical field. But, for a > pre-existing data record - those Logical fields are all Blank - which > essentially evaluates to a False. When the screen reads the data - it > sees all the blank fields as False. And, if I try to Default one of > those things to a True - how do I know whether the field was set to > False by a User - and now the program is trying to push it to be > True/Yes? > > > > For the pre-existing records - with Blanks in the fields - is there a > way I can test for them being Blank/Un-Modified vs. False? > > > > The other option - as suggested by my QA Tech buddy - is to replace the > field with True through out the Whole DBF file - and, I would also have > to change the program that initially Creates the DBF record - and change > it to force that field value to a True to start off with... > > > > Thanks, > > -K- > > > > Senior Developer > > Waitex Information System, Inc. > > P Save a tree. Don't print this e-mail unless it's really necessary. > > > > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/289ea162f5642645b5cf64d624c66a140e260...@us-ny-mail-002.waitex.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
