CursortoXml

[FoxWing]

Hi,

As i'm developing my COM Server, i have a function that needs to return a result in XML format. I don't need the physical XML file anyway.

But, I have no knowledge of accomplished this. All i got was i managed to output the result to an XML phisical file.

My codes :

SELECT us_userid dob as DataOfBirth FROM us_user INTO cursor tmpUs_user

CURSORTOXML("uv_Val", "c:\uv_val.xml", 1, 512, 0, "1")

RETURN ??? <-----how to return from here ?


Please help.

 

[craigsboyd]

To get your XML into a variable, use something like the following...

Local lcReturn

SELECT us_userid dob as DataOfBirth FROM us_user INTO cursor tmpUs_user

CURSORTOXML("tmpUs_user","lcReturn",1,48,5,"","","")

Return lcReturn

However, if you still need the physical file and want to return your resulting XML as a string as well, consider using FILETOSTR()...

Local lcXMLFileName
lcXMLFileName = "c:\uv_val.xml"
SELECT us_userid dob as DataOfBirth FROM us_user INTO cursor tmpUs_user

CURSORTOXML("uv_Val", lcXMLFileName, 1, 512, 0, "1")

RETURN FILETOSTR(lcXMLFileName)

http://www.sweetpotatosoftware.com