PRB: Cannot Access VFP Parameterized Views Remotely

Last reviewed: September 9, 1996
Article ID: Q148895
The information in this article applies to:
  • Microsoft Visual FoxPro ODBC Driver, version 1.0

SYMPTOMS

When you open a Visual FoxPro database (.DBC) using the Visual FoxPro ODBC driver, it does not display remote or parameterized views. In particular, if you open a Visual FoxPro .DBC from Microsoft Access 7.0, some views that belong to the database are not listed in the Link Tables dialog.

CAUSE

The data sets that are not listed are parameterized views and remote views. The SQLTables() ODBC function of the Visual FoxPro ODBC driver returns the list of table names stored in a specific data source. The result set returned by this funcion does not include remote or parameterized views contained in a .DBC.

Visual FoxPro local parameterized views require that a variable be initialized and passed to the view before it is opened. If this variable is not initialized, an error occurs. The ODBC driver does not display a dialog that would allow you to make a variable assignment to initialize the parameter. Therefore, to prevent an error, parameterized views are not accessible through native SQL Pass Through functions and the interface. You can, however, open a parameterized view from a trigger by initializing the parameter in the trigger code before opening the view.

STATUS

This behavior is by design.

MORE INFORMATION

For more information about the SQLTables() ODBC function, refer to the Microsoft "ODBC 2.0 Programmer's Reference and SDK Guide," pages 511-515.

Steps to Reproduce Behavior

  1. Using the Visual FoxPro ODBC Driver, create a data source to the Visual FoxPro tastrade database, located in the Samples\Mainsamp\Data directory.

    a. Start the OBDC Driver Manager. b. Click the Add button to add a driver. c. In the list of drivers, select the Microsoft Visual FoxPro Driver. d. In the data source dialog, click the Visual FoxPro Database (.DBC) as

          the database type.
    
    e. Select Tastrade.dbc, located in the Samples\Mainsamp\Data directory.

  2. Start Microsoft Access version 7.0 and create a new database.

  3. Right click and select "Link Tables" from the shortcut menu.

  4. Select ODBC Databases in the "Files of type" dropdown.

  5. Click the Data source to Tastrade.dbc.

The employee listing view is not listed in the Link Tables dialog box because it is a parameterized view and is not accessible via the interface. When you open and modify the tastrade database in Visual FoxPro, the Employee listing view is available.


Additional reference words: 1.00 vFoxwin 3.00 3.00b
KBCategory: kbinterop kbprb
KBSubcategory: FxinteropGeneral




THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 9, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.