>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.
I think it could be simpler to build XML directly w/o using CURSORTOXML(). You should explore it.
--sb--