Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set Filter to
Message
From
07/03/2003 16:59:14
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
07/03/2003 14:31:25
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00762585
Message ID:
00763053
Views:
15
That's not necessarily true either. If you want to do a search on two fields

LOCATE FOR FIELD1=SOMETHING AND FIELD2=SOMETHING

LOCATE FOR FIELD1=SOMETHING

LOCATE FOR FIELD2=SOMETHING

You'll need three index tags to do what you suggest. The best practice is to use SQL and have the two indexes and not to grab more data than necessary.

>Hi Fred,
>>
>>Not entirely true. As long as the filter matches an index tag, you'd be hard pressed to notice a slow down. If it doesn't match an existing tag, then your statement is VERY true.
>
>If we talk about good practice.. There is nothing to compare:
>
>
>set near on
>seek mykey
>scan rest while mykey = myfieldcode
>endscan
>
>
>SET FILTER will be good enough just: As long as the filter matches an index tag.. To find the EOF() state... huff.. :)
>
>Claudio
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform