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?