1 reply to this topic

[RvHaandel]

Hey everyone,

During our migration from Installshield 10.5 to Installshield 2008 I encounter this problem:

When I run this piece of code I receive an nResult that has the value: 1615

function _Get_View( hInstall, strTableName, hTableView, hDataBase )
string strQuery;
number nResult;
HWND hView;
begin
(Comments: strTableName = "Condition")
// Select all columns and all rows in the named table
strQuery = "SELECT * FROM " + strTableName;

// Obtain a handle to the active database
hDataBase = MsiGetActiveDatabase( hInstall );

if( hDataBase = 0 ) then
MessageBox( "Unable to open active database", SEVERE );
abort;
endif;

// create a view object as specified by strQuery
nResult = MsiDatabaseOpenView( hDataBase, strQuery, hView );
(Comments: nResult = 1615 here)
if ( nResult != ERROR_SUCCESS ) then
MessageBox( "Error opening view on table " + strTableName, SEVERE );
abort;
endif;
end;

I know that this 1615 error stands for ERROR_BAD_QUERY_SYNTAX but I really have no idea what I am doing wrong.
I really don't understand what the problem is because this same code always worked in Installshield 10.5.

Can someone please help me out?

[Stefan Krueger]

Does your setup include any feature conditions?
While older InstallShield versions always added all tables to the msi, even if they are contain no records, newer versions drop empty tables.