FactoryTalk Optix Studio Help Center

Store

BrowseName: Store
SuperType: Object(BaseObjectType)

Properties

Name	BrowseName	DataType	Description
Max column name length	MaxColumnNameLength	UInt32	Maximum length of column names
Max columns count	MaxColumnCount	UInt32	Max columns count
Data type compatibility map	DataTypeCompatibilityMap	NodeId	Map of the compatibility for the column data type
Status	Status	Store status	Database connectivity status
Tables	Tables	Table	Database tables

Methods

Add table

BrowseName: AddTable

InputArguments
Name	DataType	Description
Name	String	Name of the new table

Remove table

BrowseName: RemoveTable

InputArguments
Name	DataType	Description
Name	String	Name of table to be removed

Rename table

BrowseName: RenameTable

InputArguments
Name	DataType	Description
OldName	String	Name of table to be renamed
NewName	String	New name for the table

Query

BrowseName: Query

ANSI SQL query

InputArguments
Name	DataType	Description
Query	String	ANSI SQL query

OutputArguments
Name	DataType	Description
Header	String	Query column header
ResultSet	BaseDataType	Query result set

Open query

BrowseName: QueryOpen

InputArguments
Name	DataType	Description
Query	String	ANSI SQL query

OutputArguments
Name	DataType	Description
QueryHandle	Guid	Handle that represents the open query
Header	String	Query column header
Count	UInt64	Count of the elements resulting from the query

Query page

BrowseName: QueryPage

InputArguments
Name	DataType	Description
QueryHandle	Guid	Handle that represents the open query
Offset	UInt32	Paged query offset
Size	UInt32

OutputArguments
Name	DataType	Description
ResultSet	BaseDataType	Query result set

Close query

BrowseName: QueryClose

InputArguments
Name	DataType	Description
QueryHandle	Guid	Handle that represents the open query

Add column

BrowseName: AddColumn

InputArguments
Name	DataType	Description
TableName	String	Table name
Name	String	Column name
DataType	NodeId	Column DataType

Remove column

BrowseName: RemoveColumn

InputArguments
Name	DataType	Description
TableName	String	Table name
Name	String

Rename column

BrowseName: RenameColumn

InputArguments
Name	DataType	Description
TableName	String	Table name
OldName	String	Name of column to be renamed
NewName	String	The new column name

Insert

BrowseName: Insert

InputArguments
Name	DataType	Description
TableName	String	Table name
ColumnNames	String	Column names for insert
Values	BaseDataType	List of records to be inserted

Object and variable references

Provide Feedback

Have questions or feedback about this documentation? Please submit your feedback here.