Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: solomon sackey
  Where is solomon sackey?
 texas
 Texas - United States
 solomon sackey
 To: tushar Kanvinde
  Where is tushar Kanvinde?
 Kolhapur, Maharastra
 India
 tushar Kanvinde
 Tags
Subject: RE: cannot access the selected table
Thread ID: 143362 Message ID: 143364 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Tuesday, August 28, 2007 9:11:37 AM         
   


> > I keep having the error message 'cannot access the selected table'
> >
> > The connection is spt,.
> >
> >
> >
> > I have a select statement but when I brought in the 'not in clause' the above error message keeps 'poping-up'
> >
> > Thanks
>
> Solomon
>
> What is the select statement?
>

select * from vpaymast where idno not in (select idno from leavemast) into cursor vpaymast1


> Regards
> Tushar

ENTIRE THREAD

cannot access the selected table Posted by solomon sackey @ 8/28/2007 8:54:27 AM
RE: cannot access the selected table Posted by tushar @ 8/28/2007 8:57:39 AM
RE: cannot access the selected table Posted by solomon sackey @ 8/28/2007 9:11:37 AM
RE: cannot access the selected table Posted by Stewart Coombs @ 8/28/2007 12:36:23 PM