>>>>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)...:)