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:
- You can access local views using the following syntax:
SELECT * FROM <view-name>
or
USE <view-name>
- You cannot use remote views from the VFP OLE DB Provider
- 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
