Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP OLE-DB provider, Stored Procedures, and C#
Message
From
26/08/2001 18:48:32
 
 
To
26/08/2001 17:49:05
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro and .NET
Miscellaneous
Thread ID:
00549274
Message ID:
00549294
Views:
19
Jim-

>When calling a stored procedure using VFP OLE DB Provider, set CommandType tp adCmdText(1) or to adCmdUnknown(8), and not asStoredProc(4).

Thanks. I had tried text, but probably not with the parens. And that is working. (The unknown causes a compile error in C# as I mentioned before.)

> VFP requires that stored procedures havew open and close parantheses "()" at

Would you tell me where you found this in the help? My searching didn't find it but I looked through about 50 topics in both help files so probably just missed a link.

Mike - If you're listening...any chance we're working on changes so the ado provider is standard? Got folks interested in using FoxPro data engine but aren't going to be crazy about it being an exception from the norm. Thanks.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform