HI Mohammed,

Because MyCur and MyCur2 is name of cursor/alias... not expression.

lcMYcur="MyCur" && expression

...
(lcMYcur) TAlias1, MYcur2 TAlias2 ;
...

MartinaJ

>hi all,
>i try to run this code below , i get error message mycur,mycur2 not found
>
>if i change the cursor to table it works
>
>

>SELECT c as  name1,d as title1,e as dept,h as office  FROM ad INTO cursor MYcur
>
>
>thisform.text1.Value=""
>thisform.text1.Value=GETFILE('xls')
>IMPORT FROM (thisform.text1.value)  TYPE XL8 
>SELECT b as  name1,c as job  FROM emp_report INTO cursor MYcur2
>
>
>SELECT  TAlias1.name1,TAlias1.title1,TAlias1.dept,TAlias1.office,TAlias2.job FROM MYcur TAlias1, MYcur2 TAlias2 ;
>**i try as (MYcur) TAlias1, (MYcur2) TAlias2 ;&&not work
>        WHERE  ALLTRIM(TAlias1.name1) = ALLTRIM(TAlias2.name1);     
>                        ORDER BY dept,job; 
>                           INTO cursor TAliascursor1
>

>
>
>thanks