Jump to content
Sign in to follow this  
JediJiver

Is there Function for NotEmpty?

Recommended Posts

I'm a long, long time user, so I feel like I should know this. Hell, I started using FM when it was under the Nashoba Systems label. Anyhow, I use the function IsEmpty all the time, but what if you want to know if a field is NotEmpty? Is this possible? It's probably a totally lame question and I'll end up kicking myself because the answer is so obvious. How the heck can I accomplish this?

Thanks

-JJ

Share this post


Link to post
Share on other sites

Yeah its probably worth mentioning that not will reverse the result of any expression in general i.e:

1=1 will normally return true (or 1)

not (expression) will return the opposite of whatever our expression evalutes to

not 1=1 is the same as writing: not true

the opposite of true of course is false or 0.

Share this post


Link to post
Share on other sites

Yeah its probably worth mentioning that not will reverse the result of any expression in general i.e:

1=1 will normally return true (or 1)

not (expression) will return the opposite of whatever our expression evalutes to

not 1=1 is the same as writing: not true

the opposite of true of course is false or 0.

Hi Genx,

Whilst the specific examples you've quoted here do give the results you are stating, the reasons for those results aren't quite what you're suggesting.

For example, if not 1=1 returns 0 (false) for the reason you suggest, then not 2=1 should return true. It doesn't. But not 0=1 does. and not (2=1) does also.

The reason for this has to do with the order of operations ('not' is evaluated first - so it shouldn't be combined with expressions in the way you're suggesting here). It can be used with results - or you can simulate the same effect (result syntax) by controlling the order of evaluation with brackets, but otherwise, not forms part of the expression rather than acting upon it. :wink2:

Share this post


Link to post
Share on other sites

Oooooho right, slipped my mind Sorry.

Lol, I put expression in brackets and then forgot to use them sigh.

Cheers.

Share this post


Link to post
Share on other sites

Alex, you are too cute. :smile2:

Share this post


Link to post
Share on other sites

Lol I am so confused...

Share this post


Link to post
Share on other sites

You are only 18; of course you are confused. Give yourself another 30 years ... you will then be confused and befuddled as well. :waytogo:

Share this post


Link to post
Share on other sites

"Oooooho right, slipped my mind Sorry"

Yeah right. ROTFLMAO.

Share this post


Link to post
Share on other sites

Are you going to DevCon?

Share this post


Link to post
Share on other sites

"Oooooho right, slipped my mind Sorry"

- No seriously - look, the second line says:

not (expression) not not expression.

But meh...

If that question re devcon was addressed to me - I was planning on going, but i got a little to friendly with my bank account and got myself 3 27" wide screens instead, they barely fit on my desk lol!! Maybe i'll be able to justify 6 grand on a one week trip next year.

Share this post


Link to post
Share on other sites

And if addressed to me, no, I won't be going this year. Two of my collegues are going so I won't be going until NEXT year; tis only fair. Good things are always worth waiting for. Let's see ... that'll be vs. 10? WOW. :shocked:

Share this post


Link to post
Share on other sites

You should ask your coworkers to take you in their suitcase. :)

Share this post


Link to post
Share on other sites

LOL!!

Share this post


Link to post
Share on other sites

Give yourself another 30 years ... you will then be confused and befuddled as well.

And, with a dash of luck, bitter.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.