What kind of expression ISBLANK() and EMPTY() accepts? 1

[IlyaRabyy]

Colleagues,

the subject says it!

Issuing

loca for not isblank(loc_code)

in rthe Command window results in the following error:

"Unallowed phrase/keyword in command: isblank(loc_code)"

issuing

loca for not empty(loc_code)

results in the similar error

"Unallowed phrase/keyword in command: empty(loc_code)"

Details:

Visual dBase ver. 5.7;

"loc_code" is the name of the field in a table currently opened in the currently selected work area.

What am I doing wrong?

TIA!


Regards,

Ilya

 

[JCreamerII]

Try this, !EMPTY(loc_code) or .NOT. EMPTY(loc_code).

Jim C.

 

[dbMark]

I'm only familiar with versions up to 5. Until then "NOT" had to be issues as ".NOT."

ISBLANK() is probably different than EMPTY() which is not in version 5.

For example, if a numeric field had previously had content or someone had previously hit Enter and a zero had been inserted into the numeric table field, it might be EMPTY() but not ISBLANK(). I hope that makes sense.

 

[IlyaRabyy]

I tried it every way I could imageine, including NOT EMPTY("LOC_CODE") and even NOT EMPTY "ALIASNAME.LOK_CODE".
Turned out it was indeed what dbMark pointed on: it's gotta be ".NOT."!
Thank you, colleague dbMark!

Regards,

Ilya