hi,
how are you.
i have 2 tables as you see TTY TABLE have tel,type with full data,
another SSS TABLE have just tel,field typ is empty i need to seek if tel=tel replace typ with type,

INDEXSEEK(), i think new thing for me.

if you have a time to write sample code it will be fantastic. if not it will be fantastic.
have a nice time

m.qasem

>>hi,
>>thank you for reply,
>>
>>this code make infinit loop,
>
>M
>
>You don't need the Scan loop. You're just trying to locate a particular record in the table. If, OTOH, you're going through one table and trying to find matching recs in another, then you need to select the other table within the loop, or better still, have matching keys (as a relationship between them) and do an
>INDEXSEEK()
>
>Where does the table sss come into this otherwise?
>
>>
>>
>>
>>>>hi all,
>>>>
>>>>any help.
>>>>i try to compare between 2 tables as under , but no result
>>>>
>>>>

>>>USE tty in 0
>>>    m.tel=tel
>>>    m.typ=typ
>>>
>>>USE sss in 0
>>>SELECT tty   &&& add this line
>>>scan
>>>   LOCATE FOR tel=m.tel
>>>     IF FOUND()
>>>       replace typ with m.typ
>>>     ELSE
>>>       replace typ WITH  SPACE(10)
>>>endif
>>>endscan
>>>