search a word on a field string RESOLVED !

[Silvio.Falconi]

I have an archivio have field "TAGS "cr 200

sample : "Computer; Portatile; apparecchi per la cucina;"

from another archive I select a field cTopic:= "computer"
and I must search the word "computer" into the first archive on all records

and I wish show only the records having on "eti" the word "computer"

How I must make ?

I try with

OrdScope(0, { || UPPER(ctopic) $ inv->TAGS })
OrdScope(1, { || UPPER(ctopic) $ inv->TAGS })

but not run well

any solution ?

[nageswaragunupudi]

SELECT INV
SET FILTER TO UPPER( cTopic ) $ FIELD->TAGS
GO TOP

[Silvio.Falconi]

not good sorry
it not search any record but on archive there is

[Marc Vanzegbroeck]

SELECT INV
SET FILTER TO UPPER( cTopic ) $ FIELD->TAGS
GO TOP

Is the text in FIELD->TAGS in upper case? Otherwise

Code: Select all  Expand view  RUN

SELECT INV
SET FILTER TO UPPER( cTopic ) $ upper(FIELD->TAGS)
GO TOP

[Silvio.Falconi]

Sorry not work

I open this archive


and select one for a sample the first record "Computer" Now I wish search on Inventario.dbf and on BiTags field if there is the word selected "Computer"
as you wrote I try with

SELECT INV
SET FILTER TO UPPER( cTopic ) $ FIELD->TAGS
GO TOP
or

SELECT INV
SET FILTER TO UPPER( cTopic ) $ upper(FIELD->TAGS)
GO TOP
then open the xbrowse

and I not see any record

But on archive inventario.dbf there are some record have the word "Computer" on that field as you can see here



it must show the 1,3,4,5 record instead nothing

Why Happen this ... where I make error ?

can I send you a test ?

[Marc Vanzegbroeck]

Silvio,

Just to be sure, what is the tame of the table name with the field 'cTtopic' (first database), and what is the one with the field 'Tags' with the text "Computer; Portatile; apparecchi per la cucina;"

[Silvio.Falconi]

write to me pls
silvio[dot]falconi[at]gmail[dot]com
I can send you a test

[Silvio.Falconi]

I trying also with
cMaMateria:="Computer"

Do while .not. be->(eof())
cstring:= alltrim(BE->BITAGS)
if alltrim(cMaMateria+";") $ cstring
aadd( aRecord, str(BE->( RecNo() )) )
Endif
? cstring
BE->(Dbskip())
Enddo

xbrowser aRecord

not found any records ... why ?

[Silvio.Falconi]

I tried also with

SET FILTER TO at(UPPER( cMaMateria ), UPPER( BE->BITAGS)) >0

but not work

[Silvio.Falconi]

Now I tried with EMAGDBU as you can see here and the command RUN OK



perhaps I found the error ...grrrrrrrrr alltrim() sorry