>>>>>>What does table_fld look like?
>>>>>
>>>>>table)fld is 254 characters long. It will work when I say
>>>>>WHERE 'MODEM' $ table_fld
>>>>>but.. when I replace 'MODEM' with THISFORM.fld.VALUE, it will not work..
>>>>>
>>>>>help
>>>>
>>>>Ok....have you tried AT(thisform.fld.vlaue,table_fld)?
>>>>
>>>>Basically
>>>>
>>>>SELECT .....;
>>>>
>>>>WHERE AT(thisform.fld.vlaue,table_fld) > 0
>>>
>>>does not work, but thanks
>>How is your field getting its original value? What I am getting at is there might be some imbedded (unreadable) characters in your field. At the command prompt, open the dbf and select a record where your field = "MODEM". Does...
>>
>>? upper(alltrim(field))="MODEM"
>>
>>return .t. or .f.?
>>
>>If it returns .f. you will need to parse your field and get rid of the imbedded characters
>>
>>To parse try something like
>>
>>STORE UPPER(ALLTRIM(FIELD)) TO mTEST
>>STORE SPACE(0) TO mFieldString
>>FOR i=1 TO len(mTEST)
>> *TEST FOR A-Z
>> IF BETWEEN(ASC(SUBSTR(mTEST,i,1)),65,90)
>> STORE mFieldString + SUBSTR(mTEST,i,1) TO mFieldString
>> ENDIF
>>ENDFOR
>>
>>REPL Field WITH mFieldString
>
>thanks for the code... I need to strip out all characters, not just a through z.
>How would I do this?
>thanks again.. rob
Rob! I am sorry that I interrupt. But as I understood we have resolved the problem already (use textbox instead of editbox). So, what is the reason to mislead people and still ask the same questions?
Edward Pikman
Independent Consultant