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: MD Dhanu
  
 
 
 MD Dhanu
 Tags
Subject: RE: VFP Error 1541 with sql command
Thread ID: 345284 Message ID: 345314 # Views: 52 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Tuesday, May 22, 2012 12:42:58 PM         
   


> 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

Was that the VFP error 1541 'Connection is busy'?

-Anders

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