Columns of type XML cannot be edited directly, however you can use the context menu to change the XML instance of an individual data cell. Clicking the Browse button that is located inside the XML column shows a popup menu allowing you to save the XML instance or load a different XML instance from the file system. It is also possible to assign an XML schema to the selected data cell.
The XML instances stored in an XML data cell in the database can be changed by selecting an XML file from the file system. DatabaseSpy presents the standard Windows Open dialog box for this purpose.
To change the XML instance of a database data cell:
1.Click the Browse button inside the data cell you want to edit.
2.From the menu that appears, select Load XML Document from File... or Save XML Document to File....
3.Do one of the following:
•In the Open dialog box, browse to the desired XML instance and click Open.
•In the Save As dialog box, select the folder where you want to save the XML file, enter a name for the file, and click Save.
4.To commit your changes to the database, click the button in the Result window toolbar.