General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I would try something like this. First decide which field the current index is created on. Read this value into memory.
lvIndexValue = IndexFld
SELECT COUNT(*);
WHERE IndexFld <= m.lvIndexValue;
INTO ARRAY aRecPos
Naturally, this assumes that the index is ASCENDING. With a DESCENDING index, reverse the sign.
Didn't run it myself, but it should work.
Steven
Previous
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