My first lookup, oops with error, Help Please

[Laura Brody]

At 08:22 PM 3/2/04, Robert M. Maguire wrote:
>Hi All,
>
>         I am trying to create a lookup statement, I am not sure what I am 
> doing
>wrong. Here is the error
>
>  "No Records Exist for this Browse Lookup Format"
>
>
>What does this mean?
>
>
>
>@wef5
>?If:
>Then: lookup match = city  k=5    i=A -nxm
>b="(brw=12fill=asc,top)[Select a city]*2  fill=asc,top)[Sele>
>20
>
>Then: end;

         My guess is that you are executing this browse lookup
when field 5 (the key) is blank. Since there are no cities
that are named "     ", there are no matches for the lookup.
This should work a little better...

@wef5    if: 5 eq ""
         then: end
         then: lookup match = city  k=5    i=A -nxm
b="(brw=12fill=asc,top)[Select a city]*2  fill=asc,top)[Sele>
          then: end

         Another problem may be if the file "city" is empty,
or if there are no exact matches for the city name (you
have -x and m flags in there).  Do you have data in there
that you expect to match?

Laura Brody, Publisher of the "filePro Developer's Journal"
+------------- Hudson Valley Computer Associates, Inc ----------+
| PO Box 859 120 Sixth Street http://www.hvcomputer.com         |
| Verplanck, NY 10596-0859 Voice mail: (914) 739-5004           |
+------ PC repair locally, filePro programming globally --------+