Forum Discussion

sguda's avatar
sguda
Regular Contributor
14 years ago

Can we retrieve the XML file values through TC8.5

Hi, I am using TC 8.5. After accessing the database record, one of the fields for the record has the link for xml file. My goal is I have to access that filed value which is xml file link and o...
sguda's avatar
sguda
Regular Contributor
14 years ago
Hi,



There is function to pass the pareameter of xml file  and convert xml field values into table.

This is th code in the sql we are using.



DECLARE @xml1 XML


SELECT @xml1 = (SELECT dataitems FROM dbo.Form_StudentData WHERE IDForm_StudentData=654588)


select @xml1


SELECT * FROM dbo.udf_GetTableFromDataItems(@xml1)


select FieldValue from dbo.udf_GetTableFromDataItems(@xml1) where IDForm_FieldDefinition = '11952'



How can i make this work in Test Complete to retrieve the xml file values. I wnat to retrieve FieldValue FROM THE TABLE GENERATED BY FUNCTION for a particular IDForm_FieldDefinition.



I am attcahing the snap shots of the table generated.