Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP3 Index Problem
Message
 
To
20/11/2006 12:38:29
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01171211
Message ID:
01171226
Views:
6
>>Looks like VFP may think that country 115 is a number and is adding the first digit from the code to that number so that;
>>
>>m.country + m.code = 118 (115 + 3)
>>
>>Try this and see if it helps;
>>
>>seek(TRANSFORM(m.country) + TRANSFORM(m.code),"table","IDX")
>
>Wouldn't seek()ing on a number in a character tag raise a "datatype mismatch" error?
>
>BTW, a colleague of mine always read that as "datatype mishmash" :).

Me too (and many Bulgarians also), because we have a MishMash meal prepared with scrambled eggs and vegetables :-))
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform