I've had a need for this in the past. InstallShield for example allows for the execution of scripts during 'logon' ( validation of the connection, typically in the UI sequence ) and has no mechanism to capture a result set. I've written a simple data driven DTF custom action that can do ExecuteScalar type queries and assign the result to specified properties. I guess you could go farther ( PROPA={0};PROPB={1} and even PROPA={R1:C0};PROPB={R1:C1} ) but I think it would get messy fast. Personally ExecuteScalar has met all of my needs so far. --- 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
----- Original Message ---- From: Rob Mensching <r...@robmensching.com> To: General discussion for Windows Installer XML toolset. <wix-users@lists.sourceforge.net> Sent: Mon, February 14, 2011 11:11:46 PM Subject: Re: [WiX-users] Read value from database query Not today. Feature request probalby open for something like this. It'd be cool if someone contributed it. On Mon, Feb 14, 2011 at 10:07 AM, kim <contactme...@gmail.com> wrote: > > We are storing product versions in a database table. Now I have 2 > questions: > > 1) With my installer how can I check if a database with specific name > exists > 2) And if database exists query the table to fetch version. > > I know one way to do this is through custom action and setting a property > with the version found. > > Was just wondering is that is some in-built support in WIX to check if > database exista and read value returned by query? > > Thanks for any reply. > -- > View this message in context: >http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Read-value-from-database-query-tp6024569p6024569.html >l > Sent from the wix-users mailing list archive at Nabble.com. > > > ------------------------------------------------------------------------------ > The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE: > Pinpoint memory and threading errors before they happen. > Find and fix more than 250 security defects in the development cycle. > Locate bottlenecks in serial and parallel code that limit performance. > http://p.sf.net/sfu/intel-dev2devfeb > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > > -- virtually, Rob Mensching - http://RobMensching.com LLC ------------------------------------------------------------------------------ The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE: Pinpoint memory and threading errors before they happen. Find and fix more than 250 security defects in the development cycle. Locate bottlenecks in serial and parallel code that limit performance. http://p.sf.net/sfu/intel-dev2devfeb _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ____________________________________________________________________________________ We won't tell. Get more on shows you hate to love (and love to hate): Yahoo! TV's Guilty Pleasures list. http://tv.yahoo.com/collections/265 ------------------------------------------------------------------------------ The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE: Pinpoint memory and threading errors before they happen. Find and fix more than 250 security defects in the development cycle. Locate bottlenecks in serial and parallel code that limit performance. http://p.sf.net/sfu/intel-dev2devfeb _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users