>The Environment:
>
>I am having trouble working with views and the form dataenvironment. I have a database with local and remote views (some of source tables are a million records or more). I then create a form and add a few of these views to the form dataenvironment. I then have a method that tries to populate picklists by running a 'Select' statement against these views into an array.
>
>
>The Problem:
>
>If I set the dataenvironment: 'NoDataOnLoad' property to True (as sugested in the programmers guide) the select statment returns 0 records. If I set this property to False, the form takes over an hour to initialize, but the select statments now work fine.
>
>I have similiar symptoms with views when I set the form to a Private Data Environment. It seem to behave the same way with remote or local views.
>
>What am I missing here? I certainly cannot have forms that take 78 minutes to load and I cannot migrate the data off SQL.
>
>Thanks for any sugestions!

Firstly, when you run SELECT_SQL against a view, you actually run it against underlined table(s). This is normal VFP behaviour and probably not what you want to achieve. The main speed issue for a view is number of records you retrieve, i.e. you should retrieve minimum amount of records, in many cases just one record. Also, in a case of client-server, remote view is not the fastest way to proceed. You may get better speed by using SQL Pass-through to call back-end stored procedures.