Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO with Parameterized Views?
Message
From
10/04/2001 12:29:49
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00494019
Message ID:
00494064
Views:
32
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
Map
View

Click here to load this message in the networking platform