I have a set of multivalued fields. I need to show them in a tabular format. (dynamic table)
How can i use xml to display multivalued field data in tabular format??
Subject: xml to display multivalued field data
I don’t quite get the question… 
I suppose you have like three fields with three values in them. Then you can do something similar to:
Dim item1 As NotesItem
Dim item2 As NotesItem
Dim item3 As NotesItem
Set item1 = doc.GetFirstItem(“Field1”)
Set item2 = doc.GetFirstItem(“Field2”)
Set item3 = doc.GetFirstItem(“Field3”)
Print |content-type: text/xml|
Print ||
Print |<?xml version="1.0" encoding="UTF-8"?>|
Print ||
Print ||
Forall v In item1.Values
Print || & EncodeXML(v) & ||
End Forall
Print ||
Print ||
Forall v In item2.Values
Print || & EncodeXML(v) & ||
End Forall
Print ||
Print ||
Forall v In item3.Values
Print || & EncodeXML(v) & ||
End Forall
Print ||
Print ||
But I guess I didn’t get the question… You’re meaning something more complicated right?
Subject: RE: xml to display multivalued field data
Thanks for your reply!!!
I have multivalued fields with item name, qty, rate.I want to display this data in tabular format in lotus notes client. I tried creating table using HTML, it displays data as i want, but problem with HTML display is when the data is edited, the HTML table does not refresh, the document needs to be saved, closed and reopen to view the updations.
I have never used XML.It want to know how i can use XML to display data i tabular format.
I have seen one forum which says u can use XML with an embedded Java applet XML viewer (Notes Client or Web Client). In the NotesDocument.QuerySave, extract the XML records and fields to place them into Notes Items (perhaps multivalue), if need be. And, in the NotesDocument.QueryOpen, place the corresponding Notes Items values into XML records and fields for display in the XML viewer.
I dont know whether this will help me out…