All,

I was reading SQL Magazine and an article by Brian Moran solved a problem I had. The problem was "How do I get the record right before and right after some seed value?"

His solution was a creative use of the MIN and MAX functions of SQL. I paraphrase his TSQL code into VFP:

This is the code:

SELECT * from wotype WHERE wotype.wotype_id = "0000000009" OR wotype_id IN(SELECT MAX(wotype_id) FROM wotype WHERE wotype_id < "0000000008") OR wotype_id IN(SELECT MIN(wotype_id) FROM wotype WHERE wotype_id > "0000000008")


SELECT * from wotype WHERE wotype.wotype_id = "0000000009" && seed value ; OR wotype_id IN(SELECT MAX(wotype_id) FROM wotype WHERE wotype_id < "0000000008") && Gets the max value of the subset of values that are less than the seed value.
OR wotype_id IN(SELECT MIN(wotype_id) FROM wotype WHERE wotype_id > "0000000008") &Gets the min value of subset of values that are greater than the seed value.

Works as advertised. This solution gets me the value right before and right after my seed value of "0000000009".


Great work Brian!