Database Functions
|
Function
|
Description
|
|
prototype INT MsiEvaluateCondition(HWND);
|
Evaluates a conditional expression that contains property names and values.
|
|
prototype INT MsiGetActiveDatabase(HWND);
|
Obtains a handle to the running .msi database, which you can use to open database views.
|
|
prototype INT MsiDatabaseApplyTransform(HWND, BYVAL STRING, INT);
|
Applies a transform to a database. A transform is a way of recording changes to a database without altering the original database.
|
|
prototype INT MsiDatabaseExport(HWND, BYVAL STRING, BYVAL STRING, BYVAL STRING);
|
Exports an installer table from an open database to a text archive file.
|
|
prototype INT MsiDatabaseGenerateTransform(HWND, BYVAL STRING, INT, INT);
|
Generates a transform file of differences between two databases. A transform is a way of recording changes to a database without altering the original database.
|
|
prototype INT MsiDatabaseGetPrimaryKeys(HWND, BYVAL STRING, BYREF HWND);
|
Returns a record containing the names of all the primary key columns for a specified table. This function returns a handle that should be closed using MsiCloseHandle.
|
|
prototype INT MsiDatabaseImport(HWND, BYVAL STRING, BYVAL STRING);
|
Imports an installer text archive table into an open database.
|
|
prototype INT MsiDatabaseIsTablePersistent(HWND, BYVAL STRING);
|
Returns an enumeration describing the state of a particular table.
|
|
prototype INT MsiDatabaseMerge(HWND, HWND, BYVAL STRING);
|
Merges two databases together, allowing duplicate rows.
|
|
prototype INT MsiDatabaseOpenView(HWND, BYVAL STRING, BYREF INT);
|
Prepares a database query, creating a view object.
|
|
prototype INT MsiFormatRecord(HWND, HWND, BYREF STRING, BYREF INT);
|
Formats record field data and properties using a format string.
|
|
prototype INT MsiViewModify(HWND, INT, HWND);
|
Modifies a database record. For a running installation, only temporary database changes are allowed.
|
|
prototype INT MsiOpenDatabase(BYVAL STRING, BYVAL STRING, BYREF HWND);
|
Opens a database file for data access. This function returns a handle that should be closed using MsiCloseHandle.
|
|
prototype INT MsiViewClose(HWND);
|
Closes an executed database view.
|
|
prototype INT MsiViewExecute(HWND, HWND);
|
Executes a SQL query.
|
|
prototype INT MsiViewFetch(HWND, BYREF HWND);
|
Fetches a record for the current database view.
|
|
prototype INT MsiRecordGetString(HWND, INT, BYREF STRING, BYREF INT);
|
Returns the string stored in a specific field of the specified record.
|
|
prototype INT MsiRecordSetString(HWND, INT, BYVAL STRING);
|
Sets the string stored in a specific field of the specified record.
|
|
prototype INT MsiRecordReadStream(HWND, INT, CHAR, POINTER);
|
Returns the string value of a record field.
|
|
prototype INT MsiRecordSetStream(HWND, INT, BYVAL BINARY);
|
Sets a record stream field from a file. Stream data cannot be inserted into temporary fields.
|
|
prototype INT MsiRecordGetInteger(HWND, INT);
|
Returns the integer stored in a specific field of the specified record.
|
|
prototype INT MsiRecordSetInteger(HWND, INT, INT);
|
Sets the integer stored in a specific field of the specified record.
|
|
prototype INT MsiViewGetColumnInfo(HWND, INT, BYREF INT);
|
Returns a record containing database column names or definitions.
|
|
prototype INT MsiRecordGetFieldCount(HWND);
|
Returns the number of fields (columns) in a record.
|
|
prototype INT MsiCloseHandle(HWND);
|
Closes a database, view, or record handle.
|
|
prototype MsiCloseAllHandles( );
|
Closes all open handles. Provided for diagnostic purposes, and should not be called for general cleanup.
|
|
prototype INT MsiViewGetError(HWND, BYREF STRING, BYREF INT);
|
Returns an error code for an error generated by MsiViewModify.
|