Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Returning rows from a VFP stored procedure to a CA
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Returning rows from a VFP stored procedure to a CA
Divers
Thread ID:
00787467
Message ID:
00787467
Vues:
55
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?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform