DBModifHelper Fields

The DBModifHelper type exposes the following members.

Fields

NameDescription
public fieldclosingQuote
closing quote, e.g. ] for SQL Server
public fieldclosingQuoteReplacement
Replacement for closing quote, if needed, e.g. SQL Server requires ] to be replaced by ]]
public fieldDBModifDefColl
DBModif definition collections of DBmodif types (key of top level dictionary) with values being collections of DBModifierNames (key of contained dictionaries) and DBModifiers (value of contained dictionaries))
public fieldFieldParamMap
Mapping of field names to parameter names (Param + number)
public fieldhadError
indicates an error in execution of DBModifiers, used for commit/rollback and for non-interactive message return
public fieldidbcnn
main db connection for DB modifiers
public fieldlistSepLocal
used to work around the fact that when started by Application.Run, Formulas are sometimes returned as local
public fieldopeningQuote
opening quote, e.g. [ for SQL Server
public fieldpreventChangeWhileFetching
avoid entering Application.SheetChange Event handler during listfetch/setquery
public fieldtrans
common transaction, needed for DBSequence and all other DB Modifiers