Search in memo fields. 1

[albewar]

Hello,
I'm just a beginner on VFP9.

Is it posssible to seach some strings or particular words from memo fileds across a table with 2000 records?
The idea is having a grid, for example, filled with matching records so you can click and show each in a form.
The memo fields have simple plain text stored on it.

Many thanks for your help.

Alberto

 

[GriffMG]

If you have a textbox on a form, you could populate a cursor with commands like this:

select MyTable
select * from MyTable where alltrim(upper(thisform.MyTextBox.Value))$upper(MyTable.MyMemoField) into cursor MyTempCursor

Regards

Griff
Keep [Smile]ing

 

[albewar]

ThankS GriffMG!

I'ts working fine This was my code line:
--------------------------------------------------------
select * from actas where alltrim(upper(thisform.Text1.Value))$upper(actas.texto1) into cursor MyTempCursor
BROWSE FIELDS texto1 * (This was the only way I could see and open the matching records)
---------------------------------------------------------
Now, I'll take a reading to the help to find out how to reflect MyTempCursor results on a grid or some form control
showing the matching records to be clicked.

Kind regards,

Alberto