Maximum number of tables open at one time?

[EMJULIAN]

I am working on a form that has 13 tables associated with it and I am also trying to use 4 views (in addition to the tables) as my data sources, so I would have 17 tables/views open at once. I create the view in view designer, but when I USE the view, one of my tables closes (the one at the bottom of the list, which is also one that the view uses for a filter condition). Also, if I close a table (so only 12 are open) and try to open more than one view, only one of view is open at a time (the last one USEd).

Is there a maximum number of tables that can be open at one time or is this a problem with my views?

Thanks!

Eve

 

[rgbean]

Eve,
The answer is partially dependent on the version of FoxPro and the OS you are running under and your available memory, but in any case 17 tables/cursors/views is not even close to the limit.

Technically speaking, if the OS supports it and you've got the memory, you can use total 65K workareas in all the datasessions.

Rick

 

[EMJULIAN]

Ok, so that answers that question - next question is what am I doing wrong? Do I have to have the base tables for a view in the same database as the views? For some reason, when I open a view that is based on TEAM and TEAMSCOR and uses a field in MEETS for a filter condition, MEETS closes when I USE the view. Any idea why?

Thanks for your help!

Eve

 

[mspratt]

Try:
SELECT 0 && Zero selects first unused workarea
before you USE your view.

Regards,

Mike

 

[JRB-Bldr]

Alternative to Mike's suggestion...

USE MyView IN 0 [ALIAS vMyView] && Within [] is optional

This will Open the View into the first unused workarea with a single line of code.

Good Luck,
JRB-Bldr