Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index offset
Message
From
30/05/1997 11:43:47
Matt Mc Donnell
Mc Donnell Software Consulting
Boston, Massachusetts, United States
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00034245
Message ID:
00034260
Views:
36
>>>Is there any way to find out what the offset of the current record is under the current index?
>>>
>>>For example I am trying to find out what the 3rd record is under a certain index for example
>>>
>>>Any help greatly appreciated.
>>>
>>>TIA
>>>
>>>Mike
>>
>>I have an idea:
>>
>>nRec = RECNO()
>>COUNT ALL WHILE RECNO()nRec TO nOffset
>>nOffset = nOffset + 1
>
>select top 3 field1 from mytable where condition order by indexfield

if we go in that direction, how about..
GO TOP
SKIP 2
Matt McDonnell
...building a better mousetrap with moldy cheese...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform