String within a string

[amwprogg]

Hi all.
I have a SQL Select statement and I want to select only the records where the "activity" character field contains a pre-defined string. The code is like:
SELECT * FROM table ;
WHERE THISFORM.activity_search.Value$table.activity=.T. ;
INTO CURSOR tmpcursor
Will that do it, because it doesn't seem to select any of the records, and I know for a fact they contain the search
string?
Many Thanks.
Andy.

 

[bborissov]

** Do not use objects directly in select
lcActivity = [%]+ALLTRIM(THISFORM.activity_search.Value)+[%]

SELECT * FROM tabl ;
         WHERE table.activity LIKE lcActivity;
INTO CURSOR tmpcursor

Keep in mind that all selects that uses LIKE, $ are very slow

Borislav Borissov

 

[amwprogg]

Thanks Borislav. I'll try that.
Andy.