Once again, I'm working at a machine that's 300 miles from my Pdox reference
books, and it's been too long since I needed to do the following. Is there a
ready-made function to tell me if a field is empty? I know I could do
this....

IF [FIELD] = ""

.....but I'm still wondering.

JoeSpareBedroom wrote:

IF ISBLANK([FIELD])

--
Larry DiGiovanni
Digico, Inc.
IT Consulting and Staffing Solutions
www.digicoinc.com
Check out www.thedbcommunity.com for Paradox resources.

"Larry DiGiovanni" <nospam@nospam> wrote


If that's in the Pdox help screen, I'm taking the rest of today off. I sat
here looking at the reference list for a good 5 minutes. :-(

Not sure if PDox DOS is different, but I think that is
IIF(isBlank([FIELD]) - two IIs
"Larry DiGiovanni" <nospam@nospam> wrote

Or that is only in a calculated field.

"Susan E. Butler" <sbutler (AT) lNoOuMiOsRbEeSrPgAeMr (DOT) com> wrote

you got lost because you were keying on the word "empty", which refers to a
table, not the word "blank", which refers to a field or a var..

--
Steven Green - Waldorf Maryland USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales - Corel CTech Paradox

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards

"JoeSpareBedroom" <dishborealis (AT) yahoo (DOT) com> wrote

no Susan.. the above is part of a multiple choice function..
IIF(whatever,a,b)

when "whatever" is TRUE, the return value is "a".. when "whatever" is FALSE,
the return value is "b".. this is true for PdoxDOS or PdoxWIN..

--
Steven Green - Waldorf Maryland USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales - Corel CTech Paradox

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards
"Susan E. Butler" <sbutler (AT) lNoOuMiOsRbEeSrPgAeMr (DOT) com> wrote

Susan E. Butler wrote:

The syntax I used was as the start of an IF statement, which I assumed he
was doing.

But if it was for a calculated field, yes, the immediate IF in PDOXDOS is
IIF.

--
Larry DiGiovanni
Digico, Inc.
IT Consulting and Staffing Solutions
www.digicoinc.com
Check out www.thedbcommunity.com for Paradox resources.

"Larry DiGiovanni" <nospam (AT) nospam (DOT) com> wrote

Your method sounds more applicable, Larry. I have a table that needs to find
values from another table. It usually finds about 75% of the values it's
looking for. Then, I aim the search at a third table to try and find the
values not found in the second table. So, ISBLANK sounds right for this
purpose.

If you have 2 (or more) tables, and you can "match" them on 1 (or more)
fields, and you want to identify records in one table which do NOT have
matches IN another table, then the ISBLANK function probably won't help
much. You'll need to build and run a "NOT IN" query - which is a different
animal altogether... Searches will throw up lots of references to these
queries...

Or... maybe explain here EXACTLY what you're trying to achieve...

- Mike