Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set relation x set filter
Message
From
14/10/2007 09:47:25
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01260883
Message ID:
01260884
Views:
28
>Which is faster: set relation to, or set filter ?

These two commands are not comparable since they serve to completely differnt purposes. Set relation is used to join two tables, set filter is used to filter the relevant records.
Anyway, I suggest that you try to avoid these commands as much as possible, you can usually write ONE line of code using SQL Select or SQL Update to get the same result as a whole bunch of lines using "old" code.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform