I don't see much of a difference between these two solutions. If one gives the result, the other also should give the same result.

>hi,
>thank you for reply
>i try it but no result no error, i have another soluation as..
>it works
>

>        if LEN(ALLTRIM(thisform.text3.value)) >= 3
> SELECT depno,depname,mobile,tel,empname,empno from emp1;
>        where  atc(trim(thisform.text3.value) ,empname)>0 ;
>         ORDER by empno;
>          into cursor crsMyCursor
>

>>Not sure if I got your description right - do you want something like this?:
>>

>>* Procedure text3.InterActiveChange()
>>Local lcEmpName
>>lcEmpName = LOWER(Trim(NVL(thisform.text3.value,'')))
>>If Len(m.lcEmpName) >= 3
>>    SELECT * FROM emp1 WHERE LOWER(empname) Like '%&lcEmpName%' Into ...
>>Endif
>>

>>
>>
>>hth
>>-Stefan
>>
>>
>>>hi all,
>>>i need help to start locate if thisform.text3.value>=3 characters
>>>
>>>via this code(atc(trim.........)
>>>
>>>

>>>SELECT depno,depname,mobile,tel,empname,empno from emp1;
>>>         where  atc(trim(thisform.text3.value) ,empname)>0 ;
>>>         ORDER by empno;
>>>          into cursor crsMyCursor
>>>

>>>
>>>thanks

 If it's not broken, fix it until it is.


My Blog