Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Moving record pointer
Message
From
19/01/2004 01:12:59
 
 
To
18/01/2004 22:37:37
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00867976
Message ID:
00868007
Views:
22
>Sergy, thanks for your interest. I have a vfp6 app that I wrote a couple of years ago. Now, I want to filter the records to only show Furniture, Accessories or both (these are the 2 main categories of the furn. co.).
>
>I want the user to be able to filter at any time without losing their place in the dbf.
>
>I know that I could use a sql, but it would change the whole architecture of my program.
>
>Thanks, Randy

So what happens if the record they're currently on is "filtered out"? Your method of GO RECNO() would filter out other records that don't match the filter, but it would have no effect on the current record. You must move the record pointer to make the filter kick in.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Reply
Map
View

Click here to load this message in the networking platform