General information
Category:
Coding, syntax & commands
Nadya,
<<
You have to move record pointer to activate the filter. Check Help on SET FILTER command.
>>
<< from VFP 5.0 Help
The condition specified by SET FILTER isn’t evaluated until the record pointer is moved in the table.
>>
I am a little confused. This is how my code looks:
!!!!!!
SELECT MyTable
set order to myindex
SET filter to fieldone = "VALUEA"
!!!!!!
When I step through the code, I notice that in my data session window, before I give the set filter command, MyTAble has all te records 9 records where fieldone= VALUEA, VALUEB etc.
But just after I give the SET FILTER, MYTable only has records where fieldone='VALUEA'. I did not have to give a skip / go statement. How can this be?
Your help is greatly appreciated.
Thank you.
Ria
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only