OpenEuphoria

sql question

• Posted by George Walters <gwalters at sc.rr.com> Oct 07, 2003
• 347 views

I would like to find a customer or part number in a data base then scroll
(next and/or previous) around that customer or part number.

For example I have tried "select * from inventory where partNbr = 1234".....
then "select * from inventory where partNbr < lastPartNbr" but that doesen't
work. It will give me the first in the file.... which is a lesser number but
not the lesser one in index order. But strangely enough "select * from
inventory where partNbr > lastPartNbr" does give me the next in index order.

Any body got any ideas on this?

george