>Hi Everyone,
>
>I have been using DBC with remote view on SQL tables and have been using a routine to set the buffering for all the open view.
>
>But, once the database has been opened is there a way to open all views with some sort of FoxPro function similar to aused() for all files/views used?
>
>I'm trying to do just a select and requery() on the views and would like to eliminate MOST of the checks to see if the view is opened or not.
>
>For example if my DBC has 10 views in it is there a way to know, or issues a
>FoxPro command and open them all?
>
>Thanks, in advance.
>
>Craig
Craig,
You could get all views in a DBC :
Open data myDBC
lnViews = ADBObjects(aViews,"VIEW")
then loop to use them ( use ('myDBC!'+aViews[m.nIndex]) in 0 ) but they might have dependencies like parameters.
Why would you want to open all at once ?
Cetin