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