Back to SPR List Previous Next
PQL LOOKUP VIA will return the next record if there is no match with the supplied keys
Minor Closed - Fixed Found:XS.01.12 02 FEB 2010 Fixed:XS.01.13 02 FEB 2010

DETAILS
 If LOOKUP VIA fails to find an exact match then it will return the next
 records information.

 In the example data below, LOOKUP via (1,3) should return a negative result
 but instead it finds the next row (2,1).
EXAMPLE PROGRAM
   KEY1 KEY2  DATA
    1    1    "key1=1 and key2=1"
    1    2    "key1=1 and key2=2"
    2    1    "key1=2 and key2=1"
    2    2    "key1=2 and key2=2"
WORKAROUND
Use a RECORD IS to lookup a record.
Back to SPR List Previous Next