Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Google-like queries in FoxPro apps
Message
 
 
To
24/02/2002 14:38:47
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00624182
Message ID:
00624299
Views:
20
Hilmar,

ATC() is going to be faster because $ is case sensitive. To use $ you either have to upper() or lower() the whole memo before you can successfully look for the existence of the search text. Even if the memo was stored as UPPER() or LOWER() I doubt that there's significant difference between the two. $ is returning a boolean ATC() is returning an integer. They are both using the underlying C string functions to do the seek so they are equally fast.

>Do you think there would be an advantage in using at() instead of $, simply to check for the existence of a string?
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform