If Statement query

[Andrew Carrick]

I want to get the If Statement to look for null data in a dec page field (e.g. <data> = empty, so do I simply click the cursor into the comparison field, or do I need to enter a space/blank?

[Jim Jensen]

I want to get the If Statement to look for null data in a dec page field (e.g. <data> = empty, so do I simply click the cursor into the comparison field, or do I need to enter a space/blank?

It's either " " or "". I believe it's without the space. Shouldn't be hard to try to validate though.

[Andrew Carrick]

Thanks, I was being lazy, should have tested it myself. Oh well, back to sleep...

[Jim Jensen]

Thanks, I was being lazy, should have tested it myself. Oh well, back to sleep...

Well, I am too - I did finally go ahead and open a document and find that it uses " " -WITH the space.

[Andrew Carrick]

Thanks Jim.

[Jim Jensen]

and I'm not saying that "" doesn't work, I can simply confirm that " " does.

[Lance Bateman]

and I'm not saying that "" doesn't work, I can simply confirm that " " does.

I've found it depends on whether the field you're evaluating is at the end of the database record or not.
If not at the end, need the space between two quotes.  If at the end, no space required.
I've found a few times that if at the end, I had to use a space though, not sure why.
If numeric, depending on version you're using, you might find you have to use 0 - remember when Applied was filling in zeroes instead of just leaving some of the items blank?