Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem in the scan loop code
Message
 
 
To
26/04/2002 17:41:43
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00649804
Message ID:
00649887
Views:
12
Thanks for the advice, Cindy. I think, I figured this one out, it probably was a problem with not correct length of lcStreet and lcCity. I padr them to the right number of letters and started the process again, but could not wait till completion. I've just checked the result through PCAnywhere and it's now 1,5MM instead of 1,6MM. So, I think my latest change worked.

>Nadya,
>
>I've had problems in the past with
>IF < NOT > SEEK(This + That + SomeOtherThing + SomethingElse, ...)
and always did better with
lcSeekString = This + That + SomeOtherThing + SomethingElse
>IF < NOT > SEEK(lcSeekString, ....)
>
>>I don't want to insert complete duplicates in the Streets table, so here is the code, I use:
>>
>>if not seek(m.State+m.City+m.lcStreet+m.OddEven+bintoc(m.lnLow),'Streets','CityStreet') or ;
>> < snip >
>>endif
>>
>>Do you see problems in it?
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform