Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Searching for a substring in a field - fastest way
Message
From
13/03/2017 06:58:11
 
 
To
10/03/2017 12:56:00
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01648880
Message ID:
01648962
Views:
41
>Thanks, Koen, but you still have to run that against each record in the table, and it is the large number of records in the table that takes the time going through, if I am not mistaken...

John,
This is way faster than 'set Filter', advise you to test it on a big table, first with table localy than also with table on a server.
Regards,
Koen
Previous
Reply
Map
View

Click here to load this message in the networking platform