Hi Joel.
>With the OLE DB driver in VFP7, will ADO Recordsets be able to work against parameterized local/remote views?
Probably not. The problem is that in VFP, parameterized views require a named parameter (eg. "WHERE COUNTRY = ?vp_Country") but the OLE DB provider doesn't know anything about parameter names. So, trying to open a parameterized view results in "SQL column vp_Country not found" even if you add a parameter with that name to the Parameters collection of the ADO Command object.
Hopefully, this will be fixed, but it seems like kind of a toughie to me.
Doug
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only