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