Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: MD Dhanu
  
 
 
 MD Dhanu
 To: MD Dhanu
  
 
 
 MD Dhanu
 Tags
Subject: RE: VFP Error 1541 with sql command
Thread ID: 345284 Message ID: 345378 # Views: 36 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Wednesday, May 23, 2012 4:01:46 AM         
   


> Dear Expert,
>
> I have error 1541 when i using same table in one query.
>
>
> select a.*,b.nm_user as usernm,c.nm_user as replynm,
> LEFT(CONVERT(VARCHAR,a.posted, 120), 20) as posted
> from trx_jobhist a
> left outer join ms_users b on b.id_user=a.id_user
> left outer join ms_users c on c.id_user=a.replyto
> order by a.posted desc
>
>
> Any body know why it's happened ?
>
>
> thanks,
> MD Dhanu


Thanks All for your kind to help me,
i found the error is caused by the return value in my SPT.


thanks,
MD Dhanu

ENTIRE THREAD

VFP Error 1541 with sql command Posted by MD Dhanu @ 5/22/2012 8:01:53 AM
RE: VFP Error 1541 with sql command Posted by Anders Altberg @ 5/22/2012 12:42:58 PM
RE: VFP Error 1541 with sql command Posted by Yuri Rubinov @ 5/22/2012 3:11:03 PM
RE: VFP Error 1541 with sql command Posted by MD Dhanu @ 5/23/2012 4:01:46 AM