Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SET FILTER and GO record-number question
Message
From
24/02/1999 20:22:50
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00191185
Message ID:
00191232
Views:
16
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform