Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursor vs. filter
Message
From
19/07/2005 09:58:35
 
 
To
19/07/2005 09:11:41
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01033773
Message ID:
01033831
Views:
19
>If I am on a specific record for an employee, and then filter, will I still be on the same record after I filter or will it put me on the first record in the filter.
>
>Example: If I am on the secord record for the employee, will I still be on that second record when I filter?
>
>Thank you so much for your help.

Christine

In order for a filter to work you must move the file pointer, so you won't be on the same record, unless you first store the Recno(), then goto that rec # after the move. e.g.

lnRecNo = RECNO()
Set filter to {whatever}
Locate
Goto lnRecNo.

Now then, as to which is faster - select or filter - that you could determine yourself very easily with a timed experiment with both methods.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Previous
Reply
Map
View

Click here to load this message in the networking platform