Hi Christopher, Thanks you for your quick response, as far I know TEMPORARY applying only for INSERT sentences, I have read here, http://msdn.microsoft.com/en-us/library/aa372021(v=vs.85).aspx Afterwards, I have tested adding TEMPORARY before and after "WHERE ..." clause with no success. Maybe I miss something more?
Enrique Domínguez Pinos -----Mensaje original----- De: Christopher Painter [mailto:[email protected]] Enviado el: martes, 23 de julio de 2013 13:56 Para: General discussion for Windows Installer XML toolset.; [email protected] Asunto: Re: [WiX-users] Updating msi database (install time) You can only do this with TEMPORARY updates once the installer is running. Maybe this blog article will help: http://blog.iswix.com/2008/07/dynamic-windows-installer-ui.html ---------------------------------------- From: "Enrique Domínguez" <[email protected]> Sent: Tuesday, July 23, 2013 6:10 AM To: "[email protected]" <[email protected]> Subject: [WiX-users] Updating msi database (install time) Hi, I'm working with wix-3.6 over VS2005 and I'm trying to make an update in a custom action at install time, for changing installer's banners. It's C# code and looks like: Microsoft.Deployment.WindowsInstaller.Database db = session.Database; string stSQL = @"UPDATE `Control` SET `Text`=? WHERE `Type`='Bitmap' AND `Control`='BannerBitmap'"; Microsoft.Deployment.WindowsInstaller.Record rc = db.CreateRecord(1); Microsoft.Deployment.WindowsInstaller.View vw=db.OpenView(stSQL); rc.SetString(1, MyBannerBmp); vw.Execute(rc); rc.SetString(1, MyDialogBmp); vw.Execute(rc); But UPDATE always fails with: 'Database Table(s) Update Failed' at vw.Execute line. I have tested a couple of different ways, always failing. Please, could somebody pointing me in right direction? I suppose as I was able to update PROPERTIES, I could update Control table fields. Thanks a lot. Best regards, Enrique Dominguez ------------------------------------------------------------------------------ See everything from the browser to the database with AppDynamics Get end-to-end visibility with application monitoring from AppDynamics Isolate bottlenecks and diagnose root cause in seconds. Start your free trial of AppDynamics Pro today! http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk _______________________________________________ WiX-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ See everything from the browser to the database with AppDynamics Get end-to-end visibility with application monitoring from AppDynamics Isolate bottlenecks and diagnose root cause in seconds. Start your free trial of AppDynamics Pro today! http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk _______________________________________________ WiX-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ See everything from the browser to the database with AppDynamics Get end-to-end visibility with application monitoring from AppDynamics Isolate bottlenecks and diagnose root cause in seconds. Start your free trial of AppDynamics Pro today! http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk _______________________________________________ WiX-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/wix-users
