Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Compare
Message
From
08/11/2005 05:38:54
 
 
To
08/11/2005 04:39:39
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 8
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01066331
Message ID:
01066346
Views:
24
>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
>>
- 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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform