FiveTech Support Forums

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 ?

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

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

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

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

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;"

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

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 ?

I tried also with

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

but not work