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

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