Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Stored procedures and the 26 parameters limit
Message
De
17/01/2005 09:17:20
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00976697
Message ID:
00977731
Vues:
35
>Hi David,
>
>You may consider using XML. VFP9 OLE DB provider supports XMLTOCURSOR() and >CURSORTOXML() functions whick makes it easier to use XML.

Thank you Sergey, that seems to be a very sound suggestion. I am seeing something like this : before a stored procedure gets called, I check whether the database is VFP and there are more than 26 parameters, and only in this case, call a custom function which transforms my parameter list into just one parameter containing XML text (then some work is to be done on the database side as well). Of what type should this one parameter be ? adLongVarChar ?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform