FIX: Few Tables Listed when Using the Remote View Wizard

MORE INFORMATION

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

1. Make sure a database container is open in Visual FoxPro and from the File menu, select New.
2. In the New dialog box, select the Remote View option button and then click the Wizard button.
3. 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.
4. 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.
5. 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.
6. Select an Oracle data source in the "Select Connection or Data Source" dialog box and log in using the correct user name and password.
7. 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.