Does the VFP OLE DB Provider work with views?

Although you can access views with the VFP OLE DB Provider, there are some limitations. Here are the basics:

  1. You can access local views using the following syntax:

    SELECT * FROM <view-name>

    or

    USE <view-name>

  2. You cannot use remote views from the VFP OLE DB Provider

  3. You cannot use parameterized views (a serious limitation). You have to remove parameters from the view and supply them as part of the query. For example:

    SELECT * FROM lv_Orders WHERE OrderID = 1000



© (c) 2026 Oak Leaf Enterprises, Inc., 1996-2026 • Updated: 07/29/18
Comment or report problem with topic