What is proper syntax for lookup with multiple fields?
Boaz Bezborodko
boaz at mirrotek.com
Fri Jan 20 12:21:45 PST 2006
I have an index using a customer number, categorization, and date. I
want to do a lookup and it isn't working.
Here is what I am doing for the lookup:
◄ If:
Then: ab(18,*)=20&"IN "
----- - - - - - - - - - - - -
◄ If:
Then: lookup actrec = acctsrec k=ab i=k -ex
----- - - - - - - - - - - - -
20 has a field definition of (6,.0) and the second field is (3,*). The
third is a date field, but I am looking for the records that have this
field empty.
The lookup doesn't generate an error, but it doesn't pull out any records.
When I do an index lookup I enter the customer number in the first
field, the "IN" in the second and leave the third blank. It works fine.
What am I doing wrong?
BTW, I'm working on 4.8.13
Thanks in advance,
Boaz
More information about the Filepro-list
mailing list