Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hello again Sergey,
I tried to implement your solution, but am not too sure about the way to do it.
My problem is the following : I'm having a list of say 50 ADO parameters to convert into a XML string. To use the CURSORTOXML() function I need to convert my parameter list into a cursor first. No problem creating a cursor with the fields name, type, size, and direction, but the value of the parameter is not of known type, and I can't make it fit into a cursor.
An ugly solution I can see would consist in having as many value columns as there are possible datatypes, and filling only the column of the datatype matching the type column. There should be something better.
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