>>>>>>in vfp60, I am SEEK to find a record. My tag is set.
>>>>>>It works fine if I use...
>>>>>>seek '124578' - but if I put this character data type of numbers in
>>>>>>a variable, the seek will not find the record. Example...
>>>>>>mynumber='124578', then SEEK mynumber (does not work).. any ideas?
>>>>>
>>>>>Is your index tag numeric or character? If it's numeric try SEEK VAL(mynumber).
>>>>---
>>>>Hi Fred and thanks for your reply..
>>>>The problem is fixed...It was an index problem. I was using a
>>>>SEEK my_seek_value with a TAG of upper(myfld1)+upper(myfld2)..
>>>>myfld1 is a ch6 and myfld2 is a ch6...
>>>>I had to do the following to fix the problem...
>>>>fld_one = substr(my_seek_value,1,6)
>>>>fld_two = substr(my_seek_value,7,6)
>>>>SEEK upper(fld_one)+upper(fld_two)
>>>>That what happens when you have to modify other peoples'
>>>>program..
>>>>Thanks all - ....:)
>>>
>>>So couldn't you just do SEEK UPPER(my_seek_value) ?
>>------
>>That would not work. I had to code
>>fld_one = substr(my_seek_value,1,6)
>>fld_two = substr(my_seek_value,7,6)
>>and do a SEEK upper(fld_one)+upper(fld_two)...:)
>
>Why not? Is your my_seek_value larger than 12 characters? Then do a SEEK LEFT(my_seek_value,12).
---------
ok Fred and thanks and Happy Thanksgiving...:))