Altova XMLSpy 2024 Enterprise Edition

Application.GetDatabaseImportElementList

Home Prev Top Next

Method: GetDatabaseImportElementList(pImportSettings as DatabaseConnection) as ElementList

 

Description

The function returns a collection of ElementListItems where the properties ElementListItem.Name contain the names of the fields that can be selected for import and the properties ElementListItem.ElementKind are initialized either to spyXMLDataAttr or spyXMLDataElement, depending on the value passed in DatabaseConnection.AsAttributes. This list serves as a filter to what finally gets imported by a future call to ImportFromDatabase. Use ElementList.RemoveElement to exclude fields from import.

 

Properties mandatory to be filled out for the database connection are one of DatabaseConnection.File, DatabaseConnection.ADOConnection and DatabaseConnection.ODBCConnection, as well as DatabaseConnection.SQLSelect. Use the property DatabaseConnection.AsAttributes to initialize ElementListItem.ElementKind of the resulting element list to either spyXMLDataAttr or spyXMLDataElement, respectively.

 

Example

See example at ImportFromDatabase.

 

Errors

1111

The application object is no longer valid.

1100

Invalid parameter or invalid address for the return parameter was specified.

1107

Import from database failed.

1112

Invalid database specified.

1114

Select statement is missing.

1119

database element list import failed.

© 2017-2023 Altova GmbH