What about your ODBC connection, are you using a DBC where the views are already established? If so is the data base container accesible to your form? If you're not using a DBC than how are you making the connection to the SQL server?

-Don

>Hello Everyone,
>
>I've just started looking at VFP 9 as our current products are still based on VFP 8.
>
>I'm looking at the Report Designer and I'm having a problem after I enter some code in to the Data Environment's OpenTables method (as shown in the What's New in VFP 9 chapter 5 page from Microsoft's VFP page). After pressing the Save icon, there's a long pause before the following message is shown:
>
>File is not open
>
>The report is based on 2 cursors, both are remote views to a SQL Server database via an named ODBC connection. What I'm wanting to do is open these cursors then create an index on the child cursor and then relate the parent.
>
>Any help is appreciated.
>
>Cheers,
>
>Andy