IsEmpty 
Author Message
 IsEmpty
I was reading some posts and saw a reference to the "IsEmpty" command for
calculations.  I have always used "If([whatever] = "", ... "    or
"If([whatever <> "",  ... " .

Is the 'IsEmpty' command a 'cleaner' way to do it?  Does that make sense?

--
Pure FMP Junkie



Wed, 11 Sep 2002 03:00:00 GMT
 IsEmpty



Quote:
> I was reading some posts and saw a reference to the "IsEmpty" command for
> calculations.  I have always used "If([whatever] = "", ... "    or
> "If([whatever <> "",  ... " .

> Is the 'IsEmpty' command a 'cleaner' way to do it?  Does that make sense?

I've been trying to use it more and more in my calculations; only because I
want to be absolutely sure that a field is totally empty.  Especially if I
have to do calculations based on imports from other application data, like
Excel.




Thu, 12 Sep 2002 03:00:00 GMT
 IsEmpty
Add another function to this tip (stolen from an Excel newsgroup):

If (IsEmpty (Trim (your field)), "Empty", "Not Empty")

I can't count the number of times I've watched a user "clear" a value from
a field by selecting the contents and hitting the space bar!



Quote:
> I was reading some posts and saw a reference to the "IsEmpty" command for
> calculations.  I have always used "If([whatever] = "", ... "    or
> "If([whatever <> "",  ... " .

> Is the 'IsEmpty' command a 'cleaner' way to do it?  Does that make sense?

> --
> Pure FMP Junkie




Fri, 13 Sep 2002 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Isnull/ Isempty fields On reports HELP!

2. IsNull / IsEmpty not working?

3. help with mdx ... iif(isempty

4. IsEmpty Not working in MDX

5. IsEmpty and IIf

6. IIF and IsEmpty

7. Does SQL Server support IsEmpty

8. isEmpty

9. Object required: 'IsEmpty(...)'

10. Newbie: How to use IsEmpty and IsNull?

11. Size of a ResultSet? (isEmpty(), hasNext())

12. Flexgrid Cell IsEmpty?


 
Powered by phpBB® Forum Software