Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement