Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ADO with Parameterized Views?
Message
De
10/04/2001 12:29:49
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00494019
Message ID:
00494064
Vues:
31
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
Fil
Voir

Click here to load this message in the networking platform