This is exactly why I entered a feature request for DTF to expose a SqlInsertTemporaryString. Unfortunatly this request was denied because the WiX team said it's easy to append temp. This is true, assuming the developer is aware of the way MSI works. I was hoping that the intellisense would expose this to help guide people to this ability.
Christopher Painter, Author of Deployment Engineering Blog Have a hot tip, know a secret or read a really good thread that deserves attention? E-Mail Me --- On Thu, 3/19/09, Olivier Cochelin <ocoche...@notocord.com> wrote: > From: Olivier Cochelin <ocoche...@notocord.com> > Subject: Re: [WiX-users] How to fill the ListView table from a Custom Action? > To: "General discussion for Windows Installer XML toolset." > <wix-users@lists.sourceforge.net> > Date: Thursday, March 19, 2009, 1:21 PM > Thank you Christopher, > > It works. I was "just" missing the TEMPORARY modifier in > the query. > > Olivier > > -----Original Message----- > From: Christopher Painter [mailto:chr...@deploymentengineering.com] > > Sent: Thursday, March 19, 2009 5:08 PM > To: General discussion for Windows Installer XML toolset. > Subject: Re: [WiX-users] How to fill the ListView table > from a Custom Action? > > > Checkout: > > http://blog.deploymentengineering.com/2008/07/dynamic-windows-installer-ui.html > > The table is different, but you should get the idea. > > Christopher Painter, Author of Deployment Engineering Blog > Have a hot tip, know a secret or read a really good thread > that deserves attention? E-Mail Me > > > --- On Thu, 3/19/09, Olivier Cochelin <ocoche...@notocord.com> > wrote: > > > From: Olivier Cochelin <ocoche...@notocord.com> > > Subject: [WiX-users] How to fill the ListView table > from a Custom Action ? > > To: "General discussion for Windows Installer XML > toolset." <wix-users@lists.sourceforge.net> > > Date: Thursday, March 19, 2009, 10:29 AM > > In my installer, I want to use a > > ListView to display the list of older > > products of our company that must be uninstalled > first. > > To do so, I would like to fill the ListView table in > a > > custom action > > written with DTF and scheduled after AppSearch in > > InstallUISequence. > > Here the code I have written in the custom action : > > > string str = String.Format("INSERT INTO > `ListView` > > (`Property`, > > `Order`, `Value`, `Text`, `Binary_`) > > > > VALUES > > ('{0}', {1}, '{2}', '{3}', > > '{4}')", > > > > > > "MyProperty", 1, "Item1", "Product > > version > > x.x", "WixUI_Ico_Exclam"); > > > view = session.Database.OpenView(str); > > > view.Execute(); > > > > It fails on the last line (view.Execute()) with the > > following exception > > : > > > Database: Table(s) Update failed > > > > The error is quite "logical" considered the Database > is > > open read-only. > > But I can't figure out how to have the Database open > in > > read/write mode. > > > > I didn't find relevant information except the > following > > thread: > > http://www.mail-archive.com/wix-users@lists.sourceforge.net/msg25355.htm > > l > > where the user doesn't report this problem. (Not sure > it > > was in a CA) > > > > Is there a way to fill the ListView from a > CustomAction or > > should I > > proceed differently ? > > > > Thanks for your answers > > > > Olivier Cochelin > > > > > ------------------------------------------------------------------------------ > > Apps built with the Adobe(R) Flex(R) framework and > Flex > > Builder(TM) are > > powering Web 2.0 with engaging, cross-platform > > capabilities. Quickly and > > easily build your RIAs with Flex Builder, the > > Eclipse(TM)based development > > software that enables intelligent coding and > step-through > > debugging. > > Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com > > _______________________________________________ > > WiX-users mailing list > > WiX-users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/wix-users > > > > > > > ------------------------------------------------------------------------------ > Apps built with the Adobe(R) Flex(R) framework and Flex > Builder(TM) are > powering Web 2.0 with engaging, cross-platform > capabilities. Quickly and > easily build your RIAs with Flex Builder, the > Eclipse(TM)based development > software that enables intelligent coding and step-through > debugging. > Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > > ------------------------------------------------------------------------------ > Apps built with the Adobe(R) Flex(R) framework and Flex > Builder(TM) are > powering Web 2.0 with engaging, cross-platform > capabilities. Quickly and > easily build your RIAs with Flex Builder, the > Eclipse(TM)based development > software that enables intelligent coding and step-through > debugging. > Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > ------------------------------------------------------------------------------ Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are powering Web 2.0 with engaging, cross-platform capabilities. Quickly and easily build your RIAs with Flex Builder, the Eclipse(TM)based development software that enables intelligent coding and step-through debugging. Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
