Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Returning a cursor from a remote VFP stored procedure
Message
De
19/10/2004 11:31:01
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00952580
Message ID:
00952649
Vues:
210
>David,

>You can return only a single value from Visual FoxPro stored procedure in VFP8 and earlier. It'll be possible to return a Recordset in VFP9.

Thank you Sergey, that makes it clear once for all. Unfortunately for us, it is unsure that we can wait until VFP9.
What about a workaround ? Can I build a custom recordset object and have VFP send it as return of a stored procedure, or will VFP only accept to return a known-type value ? After all, when I call a stored procedure through ADO, I can retrieve the result as a single-rowed RecordSet, so it's an object.
I thought about using views too, but how could I make views which can be called only with the parameters I want ? I mean, for instance allowing access to "books by author A" but disallowing access to "all books".
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform