#include <windows.h>
#include <Msiquery.h>
#pragma comment(lib, "msi.lib")
//-------------------------------------------------------------------
// Function: OpenViewOnDatabase
//
// Arguments: hDatabase - handle to a MSI package obtained
//                                        via a call to MsiOpenDatabase
//
// Returns: UINT status code. ERROR_SUCCESS for success.
//--------------------------------------------------------------------------------------------------
UINT __stdcall OpenViewOnDatabase(MSIHANDLE hDatabase)
{
	if (!hDatabase)
		return ERROR_INVALID_PARAMETER;

	PMSIHANDLE hView = 0;
	UINT uiReturn = MsiDatabaseOpenView(hDatabase, 
		     			       TEXT("SELECT * FROM `UnknownTable`"),
					       &hView);

	if (ERROR_SUCCESS != uiReturn)
	{
		// try to obtain extended error information.

		PMSIHANDLE hLastErrorRec = MsiGetLastErrorRecord();

		TCHAR* szExtendedError = NULL;
		DWORD cchExtendedError = 0;
		if (hLastErrorRec)
		{
			// Since we are not currently calling MsiFormatRecord during an
			// install session, hInstall is NULL. If MsiFormatRecord was called
			// via a DLL custom action, the hInstall handle provided to the DLL
			// custom action entry point could be used to further resolve 
			// properties that might be contained within the error record.
			
			// To determine the size of the buffer required for the text,
			// szResultBuf must be provided as an empty string with
			// *pcchResultBuf set to 0.

			UINT uiStatus = MsiFormatRecord(NULL,
							 hLastErrorRec,
							 TEXT(""),
							 &cchExtendedError);

			if (ERROR_MORE_DATA == uiStatus)
			{
				// returned size does not include null terminator.
				cchExtendedError++;

				szExtendedError = new TCHAR[cchExtendedError];
				if (szExtendedError)
				{
					uiStatus = MsiFormatRecord(NULL,
								     hLastErrorRec,
								     szExtendedError,
								     &cchExtendedError);
					if (ERROR_SUCCESS == uiStatus)
					{
						// We now have an extended error
						// message to report.

						// PLACE ADDITIONAL CODE HERE
						// TO LOG THE ERROR MESSAGE
						// IN szExtendedError.
					}

					delete [] szExtendedError;
					szExtendedError = NULL;
				}
			}
		}
	}

	return uiReturn;
}