FOR LAST - Query, giving wrong result

[Matt_Johndon]

I'm looking to use the following query to find the last tender id.

FOR EACH tender-table NO-LOCK WHERE tender-table.kco = 1 BY tender-table.id:
DISPLAY tender-table.id.
END.


This query looks at all the tender id's and brings back all the results of all the id's in ascending order. The results i get are

1,035 1.036 ...... 1,060 1,061 1,062 1,063 1,064 1,065 1,066

FOR LAST tender-table NO-LOCK WHERE tender-table.kco = 1 BY tender-table.id:
DISPLAY tender-table.id.
END.


However when i use this query to find the last id, i get the result,

1,061

When I should be seeing the result 1,066. Can anyone suggest why this is happening?

Continue reading...