PowerBuilder ‘Gotcha’ – Datawindow XML

Posted on Wednesday, June 30th, 2010 at 8:20 pm in

A feature was added to the datawindow as of version 9 which allows you to save the data as XML (you have to define an export template).

The syntax is:

ls_xml_data_set = dw_1.object.datawindow.data.xml

However, if you have a large string column in the datawindow  – something like a CHAR(32000) – and it contains a lot of data, your xml element for this will be blank.  As a test try exporting a large datawindow definition to a text file and then copy / paste it to the column in your xml datawindow and then save it.   Check the database to see that the data was saved.  Retrieve the data into the datawindow and then grab the xml as above.

You might also be interested in