Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to find which record shows first in a grid
Message
 
À
10/10/2012 12:57:23
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01554683
Message ID:
01554688
Vues:
58
>>>Is there a way to find which record shows in the first row of a grid? RECNO() would be fine.
>>>
>>>TIA,
>>>
>>>Alex
>>
>>It depends of the current ORDER.
>>Maybe the MIN() value of the order KEY?
>>or even:
>>
>>SELECT GridRecordSource
>>GO TOP
>>lnTOPRecNo = RECNO()
>>
>>
>>but you should change it everywhere you change the current order of that table.
>
>In that case,
>
>select 0
>use dbf("gridrecordsource") again alias src2
>* do something to set order the same as in the grid
>go top
>lnTopRecNo=recno()
>use
>
*** there where you change the ORDER:
SELET gridrecordsource
lnCurrentRecNo = RECNO()
SET ORDER TO ....
GO TOP
lnTopRecNo=recno()
GO lnCurrentRecNo
Don't know which is faster :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform