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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement