Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Yuri Rubinov
  Where is Yuri Rubinov?
 Philadelphia
 Pennsylvania - United States
 Yuri Rubinov
 To: Fred Cohen
  Where is Fred Cohen?
 Moorestown
 New Jersey - United States
 Fred Cohen
 Tags
Subject: RE: Test for Table Open
Thread ID: 33620 Message ID: 33663 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: General VFP Topics
Date: Monday, December 01, 2003 3:00:39 PM         
   


You can also use Aused() function to collect info about all table aliases open. Something like:

if aused(atemp)>0
for ia =1 to alen(atemp,1)
sele (atemp[ia,1])
?dbf() && table name may differ from alias
endfor
endif



> I know that there are several functions ,like USER() , that allow a method to test whether a table is open in a specific work area. Can anyone tell me if there is any function that will test for whether a table is open in any work area whatever?
>
> Fred888


ENTIRE THREAD

Test for Table Open Posted by Fred Cohen @ 11/30/2003 8:39:23 PM
RE: Test for Table Open Posted by Eric den Doop @ 11/30/2003 10:15:35 PM
RE: Test for Table Open Posted by Yuri Rubinov @ 12/1/2003 3:00:39 PM
RE: Test for Table Open Posted by suhas hegde @ 12/1/2003 3:36:09 PM
RE: Test for Table Open Posted by Yu-Wah Cheung @ 12/4/2003 12:36:45 PM