If a regular remote view is created, all of the tables are listed in the
Open dialog box that appears after making the connection to the database.
All of the tables may or may not appear depending on the backend database
system to which you are connecting. When using Oracle as the backend, all
of the tables consistently do not appear when using the Remote View Wizard.
This same behavior could effect other database systems as well.
Steps to Reproduce Behavior
- Make sure a database container is open in Visual FoxPro and from the
File menu, select New.
- In the New dialog box, select the Remote View option button and then
click the Wizard button.
- In the Remote View Wizard dialog box, Step 1 - Choose Data Source is
displayed in the drop-down list box. Select the "ODBC data sources"
option button and in the "Available Data Sources" list box, choose a
data source that will connect to an Oracle server.
- In the Remote View Wizard dialog box, "Step 2 - Select Fields" is now
displayed in the drop-down list box. Count the number of tables listed
in the Tables list box.
- Select the Cancel button in the Remote View Wizard. From the File menu,
choose New. In the New dialog box, select the Remote View option button
and then select the "New File" button.
- Select an Oracle data source in the "Select Connection or Data Source"
dialog box and log in using the correct user name and password.
- When the Open dialog box appears, count the number of tables listed in
the Tables list box.
NOTE: You will see fewer tables available when you use the wizard to create
the remote view. This has been fixed in Visual FoxPro 6.0.