Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to search memo field
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00229554
Message ID:
00229591
Views:
18
You could have a text box on a form for the user to type in some word fragment, word, or phrase to search for in the meom field. To search through multiple records:

SOME_VALUE = upper(alltrim(ThisForm.NameOfTextBox.Value))
locate for SOME_VALUE $upper(MyTable.MemoFieldName)

You could then display the memo field contents of that record, then use CONTINUE to search for the next record that matches the value.
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform