Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 To: mohammed qasem
  Where is mohammed qasem?
 amman
 Jordan
 mohammed qasem
 Tags
Subject: RE: select
Thread ID: 209677 Message ID: 209735 # Views: 1 # Ratings: 1
Version: Visual FoxPro 9 Category: Forms
Date: Tuesday, December 30, 2008 4:45:36 PM         
   


thank you very much,
> but i have empname at 2 tables ,i need to get it from emp1.dbf
> i use
> thisform.text5.value = TAliascursor1.empname&& i get empname from another table,
>
> i try it as below it works, but i look fo another way to do it.
>
> If Not Used('emp1')
>     USE emp1.dbf Alias emp1 Again In 0 Shared
> Endif
> 
> SELECT emp1
> LOCATE FOR emp1.empno=thisform.text4.value
> IF FOUND()
>   thisform.text5.value=emp1.empname
> .
> .
> 

 LOCAL lnEmpNo
  lnEmpNo = thisform.text4.value
  IF NOT EMPTY(M.lnEmpNo)
  SELECT empname FROM Emp1 WHERE empno = ?lnEmpNo
  INTO ARRAY aTemp
  Thisform.Text5.Value=aTemp(1)
  RELEASE aTemp 
  ENDIF 

-Anders

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