>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
>>scan
>> LOCATE FOR tel=m.tel
>> IF FOUND()
>> replace typ with m.typ
>> ELSE
>> replace typ WITH SPACE(10)
>>endif
>>endscan
>>
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.