Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Searching memo fields
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00334887
Message ID:
00334890
Views:
28
SEEK() won't work, unless you have an index like:
INDEX ON "My string" $ MyMemo TAG MyTag
Which is not likely, since the string is hard coded and you would need an index for each string you want to search. The following will work, but may be slow on a large table, since Rushmore can't kick in:
LOCATE FOR "My string" $ MyMemo

IF Found()
   ...
ENDIF
HTH
>I would lke to search for a specified character string in a memo field, can I use a standard SEEK(), or do I need to use something else?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform