Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SET FILTER and GO record-number question
Message
De
24/02/1999 20:22:50
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00191185
Message ID:
00191232
Vues:
17
>I set a filter on the current workarea. Then a "GO 1". Well, record 1 did not satisfy the filter condition. Did the record pointer move to record 1? Will any table.field references, reference the fields in record 1?
>
>Thanks - Brenda



Go Top, Go Bottom instead!!
You can try it at command window.

Use MyTable Again in 0 shared Order Tag MyKey
Set Filter to left(MyKey,1) = "C" && all MyKey start at "C"
Browse && after open the browse window, use mouse back to cmd window!
Go Bottom && visit the last record which is correct at filter require!
* Then, you need to click the Browse window to see OR
* use the Browse Command Again!
Go Top && Try to visit the top correct condition record!

Remember that after filtering, the Go, SKIP command WILL NOT work without filter!
SKIP -1 && will find the record previously AND Work in Filter condition!

For me, I would use a variable to Carry the myKey value and seek/locate it! This will previous some unexpectable or out of you want record number..
^_~ Good Luck!
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform