Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: alan shulman
  Where is alan shulman?
 utica
 New York - United States
 alan shulman
 To: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 Tags
Subject: RE: data sessions and tables in forms
Thread ID: 345327 Message ID: 345332 # Views: 32 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Forms
Date: Tuesday, May 22, 2012 4:45:24 PM         
   


> > I have this command in the combo box of a form called by my Main form with a button:
> >
> > **
> > SELECT policy FROM valanntable INTO ARRAY thisform.alPolicies
> > **
> >
> > This 'sub' form is modal and has a private data session. The 'valanntable' table is open in another data session, 1. I'm getting a file in use message with this command. Do I have to close the table in the other session? Whats the best way to do that?
>
>
> Hi,
> Well you could use private data sessions to avoid this.
>
> Pete "the IceMan", from the Great White North of Canada.
> www.marathongriffincomputers.com



This second form is a private data session and I'm getting this error.

Ok, it works if I first use the table as shared.

ENTIRE THREAD

data sessions and tables in forms Posted by alan shulman @ 5/22/2012 4:24:18 PM
RE: data sessions and tables in forms Posted by Pete Sass @ 5/22/2012 4:41:11 PM
RE: data sessions and tables in forms Posted by alan shulman @ 5/22/2012 4:45:24 PM
RE: data sessions and tables in forms Posted by Pete Sass @ 5/22/2012 6:23:48 PM