Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SetFilter()
Message
From
17/02/2003 09:54:15
 
General information
Forum:
Visual FoxPro
Category:
CodeMine
Title:
Miscellaneous
Thread ID:
00753658
Message ID:
00754072
Views:
21
Morning to you Mr. Borges:

>Didn't know the SET KEY guy. Thanks to introduce me.

Glad it helped. FWIW, you can also (using native VFP) set a range using SET KEY like so :-


SET KEY TO LowestValue RANGE HighestValue


So, you could use SET KEY on a date index and have a range of dates between a start and and end date. I have always used SET KEY because of its speed. It is also better in many circumstances than using SET RELATION TO (when relating cursors) because it actually produces a set of records that have a start and an end, whereas SET RELATION TO only relates a single record in a child cursor to a parent record on the child's FK. So, not only is it better than using SET FILTER, it also is the key to getting a set of records in a VFP navigational cursor (as opposed to a SQL recordset).

Let me know how stunning this form becomes <s>.

Later
-=Gary
Previous
Reply
Map
View

Click here to load this message in the networking platform