Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index offset
Message
De
30/05/1997 11:43:47
Matt Mc Donnell
Mc Donnell Software Consulting
Boston, Massachusetts, États-Unis
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00034245
Message ID:
00034260
Vues:
34
>>>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...
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform