Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
I just wanted to come back at this one, and say that after a lot of surprises and of hard work, the XML solution WORKED ! Thank you again for your suggestion.
For the moment I opted for the suboptimal solution of using CURSORTOXML() after creating a lot of cursors, depending of the type and size of the parameters. Then the call to a VFP stored procedure is replaced by a call to a special stored procedure, which takes as parameters the XML strings and the name of the stored procedure. Each stored procedure has dictionary entries stating its parameters names, hence the parameters passed through XML can be matched. This allows both to work around the 26 parameters limit and to pass parameters by name instead of by position.
Still to do are :
- Finishing the code parser which will analyze the stored procedure code found in the data dictionary to fill user dictionary tables with the procedure names and parameters.
- Improving the performance.
- Understanding how to have XMLTOCURSOR() correctly restore texts with carriage returns in them. Any idea ?
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