Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Returning rows from a VFP stored procedure to a CA
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Returning rows from a VFP stored procedure to a CA
Miscellaneous
Thread ID:
00787467
Message ID:
00787467
Views:
56
Hi gang,

Here's one for your collective gray matter...

I have a VFP DBC with a stored procedure that SELECTs some information. I can, of course, return that information in a browse window or to a cursor in VFP by opening the DBC and issuing "DO MyProc" in the command window.

QUESTION: How do I return that information to a CursorAdapter using the VFP OLEDB provider? Just placing the command "DO MyProc" in the SelectCmd property doesn't work (CursorFill returns false). I don't think it's the CA itself, since the same CA works fine if I populate SelectCmd with the direct query and don't use the call to the VFP sproc (which, of course, I can't do over the long term, since the CA is intended to have multiple instances which each call different sprocs in the VFP DBC, all returning different data sets).

Any ideas would be *greatly* appreciated, folks...

TIA,
Evan Pauley, MCP
Positronic Technology Systems LLC
Knoxville, TN

If a vegetarian eats vegetables, what does a humanitarian eat?
Next
Reply
Map
View

Click here to load this message in the networking platform