Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Yu-Wah Cheung
  Where is Yu-Wah Cheung?
 
 United Kingdom
 Yu-Wah Cheung
 To: suhas hegde
  Where is suhas hegde?
 sirsi
 India
 suhas hegde
 Tags
Subject: RE: Test for Table Open
Thread ID: 33620 Message ID: 33856 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: General VFP Topics
Date: Thursday, December 04, 2003 12:36:45 PM         
   


> > 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
>
> whats wrong with the used() function?
> eg:
>
> if !used('customer')
> use customer in 0
> endif
>
> select customer
> .......
> ....
>
> suhas

Hi Suhas,

USED() is scoped to the current data session. If you have several screens open and using Private DataSession then USED() will not find the other occurrence of the table being used.

Regards

Yu-Wah

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