Public Attributes | List of all members
Wix::Extensions::DataSource::ODBCExecute Class Reference

Public Attributes

string Id
 
string Sql
 
string OutputFilename
 
string XsltFilename
 
YesNoType EvaluateProperties
 
string ConnectionId
 
YesNoType ExecuteOnInstall
 
YesNoType ExecuteOnUnInstall
 
string Delimiter
 
SqlType Type
 
string BasePath
 

Detailed Description

Implements execution of an ODBC statement.

    ODBCExecute can be nested under a database (eg. MSSQLDatabase), component or product/module/fragment. When nested
    under a database or component, conditions of the latter apply. When nested under product, module or fragment, you
    can specify explicit conditions that will be combined with ExecuteOnInstall and ExecuteOnUnInstall.

    Note that ODBCExecute runs automatically after databases are created on install and before databases are dropped
    on uninstall.

May be nested under Component, MSSQLDatabase, AccessDatabase.

Member Data Documentation

string Wix::Extensions::DataSource::ODBCExecute::BasePath

Base path for include commands with relative path in sql script.

string Wix::Extensions::DataSource::ODBCExecute::ConnectionId

MSSQLConnection to use for executing this statement (when not nested under a database element).

string Wix::Extensions::DataSource::ODBCExecute::Delimiter

Batch delimiter. The contents of the SQL file will be split and executed one-by-one. Delimiter is case-insensitive, recognized only at the beginning of line. Either Type or Delimiter may be specified, not both.

YesNoType Wix::Extensions::DataSource::ODBCExecute::EvaluateProperties

Set to yes to evaluate MSI properties within the SQL query, no to automatically encode all [ ] characters.

YesNoType Wix::Extensions::DataSource::ODBCExecute::ExecuteOnInstall

Execute statement at install time.

YesNoType Wix::Extensions::DataSource::ODBCExecute::ExecuteOnUnInstall

Execute statement at uninstall time.

string Wix::Extensions::DataSource::ODBCExecute::Id

Identifier for the ODBC statement (primary key).

string Wix::Extensions::DataSource::ODBCExecute::OutputFilename

Save structured output to an XML file.

string Wix::Extensions::DataSource::ODBCExecute::Sql

SQL statement to be executed.

SqlType Wix::Extensions::DataSource::ODBCExecute::Type

Type of the sql script (SqlServer, Oracle, ...). This will set appropriate delimiters for sql splitting, e.g. 'go' for SqlServer; also.will provide support for insertion commands, e.g. ':r' for SqlServer.

string Wix::Extensions::DataSource::ODBCExecute::XsltFilename

Transform structured output during save using an XSLT transform.


The documentation for this class was generated from the following file:


© Application Security Inc. - All Rights Reserved http://msiext.codeplex.com