1 reply to this topic

[Barbara]

I have a problem executing SQL Delete statments from the InstallScript. The function returns always ERROR_SUCCES, but nevertheless seems not to be working. Here is what I am doing:

Created my private database table with the name ADSDialogs and the fields DisplayName, Index, Display (all strings)

The values are initially filled.

During installation I make the following actions: (in InstallSkript)
hDB = MsiGetActiveDatabase(hMSI);
szQuery = "DELETE FROM ADSDialogs WHERE DialogName='InstallWelcome'";
nRes = MsiDatabaseOpenView(hDB, szQuery, hView);
nRes = MsiViewExecute (hView, NULL);
nRes = MsiViewClose(hView);
nRes = MsiCloseHandle(hRec);
nRes = MsiCloseHandle(hView);

All return values are ERROR_SUCCESS

Afterwards I select for this deleted item and I can see, that the entry has not been deleted from my database table.
Also subsequent insert statements for DialogName = DialogName='InstallWelcome' are failing.
Return code is ERROR_FUNCTION_FAILED

Any ideas whats going wrong ? Or is it not possible to delete database entries at runtime ?

Thanks in advance

Barbara

[Barbara]

Found the solution:
The database table one likes to work with must be created at runtime, then everything ist working. I used a precreated databasetable and for this you can not do Update and Delete - Statements.

Barbara