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?
Quote from: Andrew Carrick on July 19, 2010, 07:01:57 AM
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.
Thanks, I was being lazy, should have tested it myself. Oh well, back to sleep...
Quote from: Andrew Carrick on July 19, 2010, 10:12:10 AM
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.
Thanks Jim.
and I'm not saying that "" doesn't work, I can simply confirm that " " does.
Quote from: Jim Jensen on July 19, 2010, 11:24:44 AM
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?