hi,

What do you want to achieve?? how i can use IF ! FOUND() OR EMPTY via 4 options(select) as below



&ineractivecahnge event
select....1
where (name1==lcName and name2==lcName1 and name3==lcName2 and name4==lcName3)
if !found() or empty

select....2
where (name2==lcName1 and name3==lcName2 and name4==lcName3)
if !found() or empty

select....3
where (name3==lcName2 and name4==lcName3)
if !found() or empty

select....3
where (name4==lcName3)
if !found() or empty

messagebox("not found")

******************************************************
If the code doesn't work, what is the error message; or what is the difference between the desired result, and the result you really get.

this code work ,no errors as
SELECT F4,F1,name4,name3,name2,name1 from x2;
where (name1==lcName and name2==lcName1 and name3==lcName2 and name4==lcName3) OR ( name4==lcName3) ;
ORDER by name1,name2,name3,name4;
into cursor crsMyCursor readwrite



thanks

>>hi all,
>>
>>i use this code below to find names i need to rewrit it .
>>
>>thanks for help
>>
>>

>> SELECT F4,F1,name4,name3,name2,name1  from x2;
>>              where  (name1==lcName and name2==lcName1 and name3==lcName2 and name4==lcName3) OR ( name4==lcName3) ;
>>              ORDER by name1,name2,name3,name4;
>>               into cursor crsMyCursor readwrite
>>
>>    &&IF ! FOUND()  OR EMPTY
>>
>>SELECT F4,F1,name4,name3,name2,name1  from x2;
>>              where  ( name4==lcName3) ;  && shure found
>>              ORDER by name1,name2,name3,name4;
>>               into cursor crsMyCursor readwrite
>>
>>

>
>For any question you ask, you should explain:
>

What do you want to achieve
>

If the code doesn't work, what is the error message; or what is the difference between the desired result, and the result you really get.