DBAction Class

DBActions are used to issue DML commands defined in Cells against the database

Inheritance Hierarchy

Namespace: DBaddinAssembly: DBaddin in (DBaddin.dll)

public class DBAction : DBModif

The DBAction type exposes the following members.

	Class	Summary
	DBAction(CustomXMLNode, Range)	constructor with definition XML and the target range for the cells containing the DBAction

	Name	Summary
	doDBModif(Boolean, String, Boolean)	do the modification defined in DBAction
	executeSQL(String)	execute the SQL text given in executeText
	executeTemplateSQL(String)	concatenate parameters into SQL template string through replacing the placeholders by the values given in paramRanges and execute the final SQL, empty values and excel errors get a NULL value.
	setDBModifCreateFields(ref DBModifCreate)	set the fields in the DB Modifier Create Dialog with attributes of object

	Name	Description
	continueIfRowEmpty	only for parametrized DBAction: if all values in the given Ranges are empty for one row, continue concatenation with all values being NULL, else finish at this row (excluding it), defaults to false
	convertAsDate	only for parametrized DBAction: comma separated locations of numerical parameters that should always be converted as date values (using the default DBDate formating)
	convertAsString	only for parametrized DBAction: comma separated locations of numerical parameters that should always be converted as strings
	paramEnclosing	only for parametrized DBAction: enclosing character around parameter placeholders, defaults to !
	parametrized	is DBAction parametrized (placeholders to be filled with values from named ranges), default to false
	paramRangesStr	only for parametrized DBAction: string of named ranges to be used as parameters that are replaced into the template string, where the order of the parameter range determines which placeholder is being replaced