Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 To: mohammed qasem
  Where is mohammed qasem?
 amman
 Jordan
 mohammed qasem
 Tags
Subject: RE: select
Thread ID: 209677 Message ID: 209736 # Views: 2 # Ratings: 1
Version: Visual FoxPro 9 Category: Forms
Date: Tuesday, December 30, 2008 4:48:00 PM         
   


> hi all,
>
> i need help to use this code below to let thisform.text5.value=t2.empname
>
>  Select  T1.time1,T1.date1,T1.roomno,T1.place1,T2.mobile,T2.tel,;
>    T2.empname, T1.discerror,T1.sno,T3.empname,T1.remark1,t1.remark2 ;
>    FROM trans1 T1 ;
>    INNER Join emp1 T2 On T1.empno = T2.empno AND T1.mark1>=0 ;
>    left Join empdep T3 On T1.fexerno=T3.empno ;
>       where T1.empno=thisform.text4.value ;
>               Order By date1,sno ;
>      nofilter ;
>         Into Cursor TAliascursor1
>   thisform.Grid1.RecordSource=" TAliascursor1"  
> 
> thisform.text5.value=t2.empname
> 

> thanks

 Select  T1.time1,T1.date1,T1.roomno,T1.place1,T2.mobile,T2.tel,;
 T2.empname as 'empName_A', ;
   T1.discerror,T1.sno, ;
 T3.empname as 'empName_B', ;
   T1.remark1,t1.remark2 ;
   FROM trans1 T1 ;
   INNER Join emp1 T2 On T1.empno = T2.empno AND T1.mark1>=0 ;
   left Join empdep T3 On T1.fexerno=T3.empno ;
      where T1.empno=thisform.text4.value ;
              Order By date1,sno ;
     nofilter ;
        Into Cursor TAliascursor1
  thisform.Grid1.RecordSource="TAliascursor1"  

thisform.text5.value=TAliascursor1.empname_A


Cetin Basoz

ENTIRE THREAD

select Posted by mohammed qasem @ 12/30/2008 1:03:50 PM
RE: select Posted by Mike Yearwood @ 12/30/2008 1:36:36 PM
RE: select Posted by mohammed qasem @ 12/30/2008 2:04:00 PM
RE: select Posted by Mike Yearwood @ 12/30/2008 4:12:13 PM
RE: select Posted by Anders Altberg @ 12/30/2008 4:45:36 PM
RE: select Posted by Cetin Basoz @ 12/30/2008 4:48:00 PM