General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only