Public Attributes | |
| string | Id |
| string | Sql |
| string | OutputFilename |
| string | XsltFilename |
| YesNoType | EvaluateProperties |
| string | ConnectionId |
| YesNoType | ExecuteOnInstall |
| YesNoType | ExecuteOnUnInstall |
| string | Delimiter |
| SqlType | Type |
| string | BasePath |
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.
Base path for include commands with relative path in sql script.
MSSQLConnection to use for executing this statement (when not nested under a database element).
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.
Set to yes to evaluate MSI properties within the SQL query, no to automatically encode all [ ] characters.
Execute statement at install time.
Execute statement at uninstall time.
Identifier for the ODBC statement (primary key).
Save structured output to an XML file.
SQL statement to be executed.
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.
Transform structured output during save using an XSLT transform.
| © Application Security Inc. - All Rights Reserved | http://msiext.codeplex.com |