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
 Tags
Subject: cannot access the selected table
Thread ID: 143362 Message ID: 143362 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Tuesday, August 28, 2007 8:54:27 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'

select * from account where idno not in (select idno from leave) into cursor account


Thanks

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