ADBOBJECTS(ArrayName, cSetting) will return the tables and view in the current database.
>How can I list the views available in the forms dataenvironment, and further, how can I list the fields in the view after the user selects which view they wish to see the fields for?
>
>I can easily do this for tables selected from local directories, but can't seem to find a way to access the dataenvironment to list items therein.
>
>I am trying to select one of the views from the dataenvironment and, once selected, fill in a listbox with the fields of the selected view. Is there a simpler way to accomplish this. What If I want to expand to look directly for databases and tables from SQL Server instead of creating views in the FoxPro database and dataenvironment?
>
>Thanks!
>Tom.
--Todd Sherman
-Wake Up! Smell the Coffee!