Autodesk SQLite Spatial (FDO) Writer Parameters
|
Database formats include a Database Connection parameter that defines and stores authentication information. For general information about sharing database connections, please see Note that Database Connection parameters differ slightly, depending on context and/or database format. |
|
Connection From the Connection parameter in a database format, you can do one of the following:
|
- When unchecked (default) and a database already exists, then tables and features are written to the existing database.
- When checked, any existing database is deleted before writing begins. Checking this option also enables the Template File parameter.
If a database does not exist when writing begins, a new database is created.
This parameter is enabled when the Overwrite Existing Database option is checked.
When a template file is specified, the destination file is replaced with a copy of the template before writing begins.
Table Defaults
- No: The table will be created if it does not exist.
- Yes: The table will be dropped if it exists, then created.
- Truncate: If the table does not exist, it will be created. If the table does exist, then all its rows will be deleted.
The default operation mode of the feature type in terms of the types of statements sent to the database.
- Insert reates new items in the destination table. If an item with the same primary key already exists, the new item is not added to the table.
- Update modifies an existing item in the destination table. If the attributes to be updated exist on the item with the specified primary key, the attributes are set to the new value. Otherwise, the attributes and their values are added to the item.
- Delete deletes existing items in the destination table that have their primary key specified.
Specifies the name of the default index attribute that is added to the feature type if no user attribute is specified with an IDENTITY index type. This parameter defaults to PRIMARYINDEX.
A comma-separated list of the geometry column names for writing.
Location columns will be created for each of the supplied geometry column names when creating a new table or matched against the existing geometry columns when writing to an existing table.
This parameter has no effect when the Writer Mode is Delete.