SQLData object configuration Commands tab

Use the Commands tab to configure:

• The timer for database and attribute access.

• The security settings for runtime command attributes.

• The handling of the attribute when the attribute quality is not GOOD.

Options are as follows. For more information about the attribute associated with each option, click the attribute link in parentheses.

Database Write Timeout Preset (DBWriteTimeout attribute)

The error time out period, in milliseconds, for database writes.

Attribute Write Inhibit Preset (AttrWriteInhibitDelay attribute)

The time preset, in milliseconds, that is used to maintain the SemaphoreAttrWrite attribute as TRUE once a transfer to the assigned attributes has been initiated.

Database Connection Timout Preset (DatabaseConnectionTimeout attribute)

The error time out period, in seconds, for connecting to the database.

Max Connections (MaxConnections attribute)

Sets the maximum number of connections allowed. The default is 100.

Command Timeout (CommandTimeout attribute)

Sets the error time out period, in seconds, for a command to execute. The default is 30 seconds.

Max Records (MaxRecords attribute)

Sets the maximum number of records allowed for the object.

AttrToDBAppendCmd (AttrToDBAppendCmd attribute)

The security configuration for this command attribute at runtime.

AttrToDBReplaceCmd (AttrToDBReplaceCmd attribute)

The security configuration for this command attribute at runtime.

TempToAttrCmd (TempToAttrCmd attribute)

The security configuration for this command attribute at runtime.

TempToDBAppendCmd (TempToDBAppendCmd attribute)

The security configuration for this command attribute at runtime.

TempToDBReplaceCmd (TempToDBReplaceCmd attribute)

The security configuration for this command attribute at runtime.

DBToTempCmd (DBToTempCmd attribute)

The security configuration for this command attribute at runtime.

DBToAttrCmd (DBToAttrCmd attribute)

The security configuration for this command attribute at runtime.

AttrToTempCmd (AttrToTempCmd attribute)

The security configuration for this command attribute at runtime.

RecordDeleteCmd (RecordDeleteCmd attribute)

The security configuration for this command attribute at runtime.

RecordSelectNextCmd (RecordSelectNextCmd attribute)

The security configuration for this command attribute at runtime.

RecordSelectPreviousCmd (RecordSelectPreviousCmd attribute)

The security configuration for this command attribute at runtime.

RecordSelectFirstCmd (RecordSelectFirstCmd attribute)

The security configuration for this command attribute at runtime.

RecordSelectLastCmd (RecordSelectLastCmd attribute)

The security configuration for this command attribute at runtime.

ErrorsResetAllCmd (ErrorsResetAllCmd attribute)

The security configuration for this command attribute at runtime.

AttrWriteCompleteResetCmd (AttrWriteCompleteResetCmd attribute)

The security configuration for this command attribute at runtime.

TempAttrQualityResetCmd (TempAttrQualityResetCmd attribute)

The security configuration for this command attribute at runtime.

DiagnosticsResetCmd (DiagnosticsResetCmd attribute)

The security configuration for this command attribute at runtime.

Query String (QueryString attribute)

The security configuration for this command attribute at runtime.

Ignore Quality for AttrToDBReplaceCmd and AttrToDBAppendCmd (AttrToDBQualityIgnore attribute)

If enabled, assigned attributes with a quality other than GOOD will be allowed to be transferred to the database using the AttrToDBAppendCmd and AttrToDBReplaceCmd command attributes.

Ignore Quality for TempToAttrCmd (TempToAttrQualityIgnore attribute)

If enabled, temporary attributes with a quality other than GOOD will be allowed to be transferred to the assigned attributes using the TempToAttrCmd command attribute.

Ignore Quality for TempToDBReplaceCmd and TempToDBAppendCmd (TempToDBQualityIgnore attribute)

If enabled, temporary attributes with a quality other than GOOD will be allowed to be transferred to the database using the TempToDBAppendCmd and TempToDBReplaceCmd command attributes.

Auto Connect to Database (DBAutoConnect attribute)

If enabled, automatic connection to the database on initial startup and automatically re-connect to the database on demand will be allowed.

Auto Update Selection (AutoUpdateSelection attribute)

Determines whether or not the current recordset is updated when the QueryString is modified.

Enable Database Connection Diagnostics (EnableDCMDiagnostics attribute)

If enabled, DCM Diagnostic attributes are made accessible (see Enable database connection diagnostics).

Database Connection Diagnostics Refresh Period (ms) (QueryPeriod attribute)

Time (in milliseconds) the DCM should be queried for new diagnostics values.