General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I don't think there's a easy SELECT-SQL statement that will give you what you want because SELECT-SQL is set based, not record based.
Why not work with LOCATE, SKIP -1 and SKIP +2?
>Here is an interesting question. Is it possible to construct a sql-select statement that will return 3 adjacent records with the wanted keyfield in the middle? That is, a specified record WHERE keyfield = lnVal plus the record before and the record after. The 2 boundary records would be for the purpose of identifying the previous and next records for navigation purposes.
>
>Any thoughts?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only