>>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.
>
>I'll have to wait until I get to the office and check, but I think you can set the variable for the parameter and use the view. I'm pretty sure I've got code lying around that does just that.
Hmmm... this was posted at 12:47 Eastern, which would be 9:47 Pacific. I like those hours. Better than being at the office at 8:00 AM.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer