ok    1  REAL field by key: parts->price(WASHER-10) = 0.02
ok    2  STRING field by key: parts->descr$(BOLT-10)
ok    3  INT field by key: parts->qty%(WASHER-10) = 1200 (value from the MATCHED row, not the current row)
ok    4  first match wins on a duplicate key: parts->id(NUT-10) = 102
ok    5  _integer = 3 after the lookup; current row still row 1
ok    6  not found: parts->price(NO-SUCH) = 0 and _integer = 0
ok    7  not found: parts->descr$(NO-SUCH) = "" and _integer = 0
ok    8  not found: parts->qty%(NO-SUCH) = 0 and _integer = 0
ok    9  key match is case-insensitive (findvalue default)
ok    10  key as an expression: parts->qty%(prefix$ + "-10") = 500
ok    11  for each visits all 4 rows while looking up BOLT-10 each time (4 x 500)
ok    12  parts->code$(3) is a row read; parts->code$(WASHER-10) is a key lookup (returns the key itself)
ok    13  descr$ is the second string field -- not the default lookup: lookup by a description finds nothing
ok    14  parts->price(descr$: "Hex bolt 10mm") looks up by the NAMED member descr$ (not the default code$)
ok    15  the default is untouched by a call-site name: a bare key still goes by code$
ok    16  a NUMERIC member can be named: parts->code$(id: 103), qty%(id: 102), and a key expression id: 100 + 1
ok    17  parts->code$(id: 999): no such id -> "" and _integer = 0
ok    18  an INT% key is coerced to the REAL member id: parts->code$(id: k%) hits
ok    19  set parts->code$: exact -- case must match by default AND when code$ is named (washer-10 misses, WASHER-10 hits)
ok    20  set parts->code$: nocase puts code$ back while descr$ stays exact -- the attribute is per member
ok    21  _integer = 3 after the case-blind hit; cursor still on row 1 through all of it

passed:  21   failed:  0 
