Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Stefan Wuebbe
  Where is Stefan Wuebbe?
 Hamburg
 Germany
 Stefan Wuebbe
 To: alan shulman
  Where is alan shulman?
 utica
 New York - United States
 alan shulman
 Tags
Subject: RE: Closing table issue in form
Thread ID: 289145 Message ID: 289159 # Views: 29 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Forms
Date: Tuesday, December 28, 2010 8:07:25 PM         
   


> Ok, so I need to establish a workarea and alias for the table I'm seeking?

In FoxPro, any open table, cursor, view, CurorAdapter has an alias name which is the synonym for a work-area.
So you do not need to establish it explicitly, it's already there.


> Like, in my init for the main form I would say something like "use 'valanntable' IN 1 INDEX 'valanntable' ALIAS val", then "if not seek(m.y, 'val', 'valanntable)"?
>

Yes, the Alias clause of the Use command determines the name, so the second parameter of Seek() is right.
The third parameter is the name of one of many index tags that you created in the yourtable.CDX file


> Also, I thought the "use in 0" would close the 'int' table because I did not name the table. How would I close that table otherwise? Do I want to say 'close tables'?
>

Use In int
&& or, since that alias was the currently selected one in the code you posted previously, just 
Use




hth
-Stefan

ENTIRE THREAD

Closing table issue in form Posted by alan shulman @ 12/28/2010 5:49:38 PM
RE: Closing table issue in form Posted by Stefan Wuebbe @ 12/28/2010 6:31:21 PM
RE: Closing table issue in form Posted by alan shulman @ 12/28/2010 7:49:22 PM
RE: Closing table issue in form Posted by Stefan Wuebbe @ 12/28/2010 8:07:25 PM
RE: Closing table issue in form Posted by alan shulman @ 12/28/2010 8:34:32 PM
RE: Closing table issue in form Posted by Ilya Rabyy @ 12/28/2010 10:28:10 PM
RE: Closing table issue in form Posted by Stefan Wuebbe @ 12/29/2010 1:46:25 PM
RE: Closing table issue in form Posted by Ilya Rabyy @ 12/28/2010 8:16:16 PM