Embedded database

Object that represents an SQLite project embedded database at runtime

BrowseName
SQLiteStore
SuperType
Store(Store)

Properties

Name BrowseName DataType Description
In memory InMemory Boolean Enable/disable non-persistent storage mode. In this mode, the store content is no longer available when the FactoryTalk Optix Application is restarted
Filename Filename String Customized name of the database file
Tables Tables SQLite store table (Inherited from Store)
Max column name length MaxColumnNameLength UInt32 (Inherited from Store)
Max columns count MaxColumnCount UInt32 (Inherited from Store)
Data type compatibility map DataTypeCompatibilityMap NodeId (Inherited from Store)
Status Status Store status (Inherited from Store)

Methods

Backup

BrowseName
Backup

Performs a hot backup to file of the embedded database

Table 1. InputArguments
Name DataType Description
OutputFilePath ResourceUri Path to the backup file
Table 2. OutputArguments
Name DataType Description
Result Boolean Result of the backup operation

Restore

BrowseName
Restore

Performs a hot restore from file of the embedded database

Table 3. InputArguments
Name DataType Description
InputFilePath ResourceUri Path to the file to be restored
Table 4. OutputArguments
Name DataType Description
Result Boolean Result of the restore operation