Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SetFilter()
Message
De
17/02/2003 09:54:45
 
Information générale
Forum:
Visual FoxPro
Catégorie:
CodeMine
Titre:
Divers
Thread ID:
00753658
Message ID:
00754073
Vues:
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform