Hi. I got an working sqlAnywhere stored procedure and I'm able to get (parse) the results partially.
fullName, ident, code, shortName, categoryName, partialPayment, viewBill 'Tigo Mobile', 'MR1011181336001', '00', 'POSTPAID', 'Pagos Tigo', 'Y', 'Y'. 'Tigo Star', 'MR1108191809001', '01', 'CABLE', 'Pagos Tigo', 'Y', 'Y'.
Cant anybody help me on this, I had triyed several way but only get null on this fields. Thank You in advance. Jef asked 03 Nov '16, 09:07 jeffreehy |
I don't consider myself to be a SOAP expert but focussing strictly on the XML and some OpenXML( ) aspects of this here is one thought I had. I can pull the GeneralResponse out in a separate query the following example shows:
so the only missing trick here is to get both (incompatable) result sets. You could combine this result with the earlier query using a UNION ALL but that would require you to align the columns adding missing ones and matching/faking types to align this all 'relationally' into one result set. It would be easier to save {fetch} your "result" directly into and XML variable and run OpenXML twice in two queries {my example was using a 'created', XML variable named "response" to which I assigned your SOAP respons string directly to it} as in this fuller example:
While this will be using 2 result sets that is still cleaner than attempting to combine them in a UNION ALL. HtH answered 03 Nov '16, 10:00 Nick Elson S... |