Application.GetDatabaseImportElementList
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. |