Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Determining relative indexed position
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Determining relative indexed position
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Network:
Novell 5.x
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01079708
Message ID:
01079708
Views:
45
I hope this one isn't too obtuse ...

Everyone knows how to test BOF() or EOF() in a naturally-ordered table, or an unordered table, what ever you wish to call it. It's usually the second thing one learns, after WAIT WINDOW "Hello World."

Is there a simple way to traverse the index directly to determine if I am either at the beginning or end of an ORDERED recordset, WITHOUT using a derivative of either of the following?
set order to 1
go top 
store recno() to nTopRec
go bottom
store recno() to nBotRec
or
local cTopRecVal, cBotRecVal
set order to tagname
go top 
cTopRecVal = table.keyField 
go bottom
cBotRecVal = table.keyField
Next
Reply
Map
View

Click here to load this message in the networking platform