I guess I wasn't especially clear in my response. Predicate is a
fancy term for operator. In this case you want
Select VA FileMan Option: SEarch File Entries
OUTPUT FROM WHAT FILE: TIU DOCUMENT// 19 OPTION (13279 entries)
-A- SEARCH FOR OPTION FIELD: 1 MENU TEXT
-A- CONDITION: NULL
I want to do a field for all records for which a
particular field holds no data.
Can I do this with a fileman search? If so, what
would the syntax be?
Thanks
Kevin
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
Just type NULL.
===
Gregory Woodhouse
[EMAIL PROTECTED]
Better. Faster. Cheaper. Pick two.
On Jun 19, 2005, at 7:03 PM, Kevin Toppenberg wrote:
I want to do a field for all records for which a
particular field holds no data.
Can I do this with a fileman search? If so, what
would the
That was easy. Thanks
Kevin
--- Gregory Woodhouse
[EMAIL PROTECTED] wrote:
Just type NULL.
===
Gregory Woodhouse
[EMAIL PROTECTED]
Better. Faster. Cheaper. Pick two.
On Jun 19, 2005, at 7:03 PM, Kevin Toppenberg wrote:
I want to do a field for all records for which a
Oops, I just tried it and it doesn't work.
Here is a screen log
Kevin
Select FM VA Filename Option: search File Entries
OUTPUT FROM WHAT FILE: TIU DOCUMENT//
-A- SEARCH FOR TIU DOCUMENT FIELD: enterED BY
-A- CONDITION: = EQUALS
-A- EQUALS NEW PERSON: NULL ?? NEW PERSON: NUll ??
NEW
Enter question mark at the CONDITION: prompt
Gregory Woodhouse wrote:
Don't use equals as the condition. You're actually using NULL as a
predicate, not a value.
===
Gregory Woodhouse
[EMAIL PROTECTED]
Better. Faster. Cheaper. Pick two.
On Jun 19, 2005, at 8:00 PM, Kevin Toppenberg
Try the @ for null ..tx/t
SORT BY: DOTID// 1.4 DOT AGE
START WITH DOT AGE: FIRST// @
GO TO DOT AGE: LAST// @
WITHIN DOT AGE, SORT BY:
FIRST PRINT FIELD: .01 DOTID
THEN PRINT FIELD: 1.4 DOT AGE
THEN PRINT FIELD:
-Original Message-
From: [EMAIL PROTECTED] [mailto:hardhats-