Hmm sounds interesting, but might be a bit too advanced for what I want to do. Are these Tables defined at design time or compile time?
I managed to get my stuff working using the previously mentioned system, so I may stick with that for now, as I'm about to be moved onto another project. Dominique. -----Original Message----- From: Wilson, Phil [mailto:phil.wil...@wonderware.com] Sent: 29 October 2009 19:36 To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Retrieving a list of all the Propertiesin thePropertyTable... I think you might as well create your own custom table, then you would return all the entries as well as define other information in the table (description, how to install etc). Phil Wilson -----Original Message----- From: Dominique Louis [mailto:dominique.lo...@amxeurope.com] Sent: Thursday, October 29, 2009 10:31 AM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Retrieving a list of all the Properties in thePropertyTable... I was trying to avoid bringing back the whole table, but as you say it can't be too big. Thanks for the SQL link as wel.. -----Original Message----- From: Peter Shirtcliffe [mailto:pshirtcli...@sdl.com] Sent: 29 October 2009 16:24 To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Retrieving a list of all the Properties in thePropertyTable... The subset of SQL used by MSI is documented here http://msdn.microsoft.com/en-us/library/aa372021(VS.85).aspx Could read the whole table and used a regex on each row ? It would be a managable size. -----Original Message----- From: Dominique Louis [mailto:dominique.lo...@amxeurope.com] Sent: 29 October 2009 16:19 To: General discussion for Windows Installer XML toolset. Subject: [WiX-users] Retrieving a list of all the Properties in the PropertyTable... Hi all, Background : I'm trying to build a Prerequisites dialog with a ListView in it. As such I'd like to make the functionality of this dialog as generic as possible, so it can be reused across several installers, so that all our installers have a common look and feel. This also gets around the ugliness of the "<Condition Message/>" and lists all prerequisites in one place. So I'm trying to find a way to handle prerequisites in a more flexible way, as the prerequisites may vary from installer to installer. So I came up with the idea that I would create properties for each prerequisite and prefix them with "PREREQ_". So you could have PREREQ_NETFRAMEWORK20 and PREREQ_IIS7 etc. I would then loop through the Property table and extract list of properties that began with "PREREQ_" who's values would be the failure error message. I would then strip off the prefix and we would be left with a property that I could do a Session.Property() call on and depending on whether that property is set, will determine if I display a tick next to that prerequisite in the ListView or a cross. Problem : I createe the following VBScript function, but I'm getting a SQL error on the "LIKE" keyword. Function GetPropertyTableView( oSessionDatabase, oProperty ) Set gPropertyTableView = oSessionDatabase.OpenView("SELECT * FROM Property WHERE Property LIKE '%" & oProperty & "%'") gPropertyTableView.Execute End Function What is the correct way to perform a SELECT on the property table? Thanks. DOMINIQUE LOUIS | IS DEVELOPER, AMX DIGITAL MEDIA GROUP AMX UK| 6TH FLOOR SALISBURY HOUSE,| LONDON WALL | LONDON | EC2M 5QQ AMX AMX AMX UK Auster Road Clifton Moor York, North Yorkshire United Kingdom YO30 4GD +44 (0) 1904 343100 office +44 (0) 1904 343101 fax AMX South 6th Floor Salisbury House London Wall London United Kingdom EC2M 5QQ +44 (0) 2076 529450 office +44 (0) 8701 991661 fax AMX Belgium Boerenkrijglaan, 96a B-2260 Westerlo Belgium + 32 (0) 1454 2763 office + 32 (0) 1454 2766 fax ###################################################################### Attention: This e-mail message is privileged and confidential. If you are not the intended recipient please delete the message and notify the sender. Any views or opinions presented are solely those of the author. This email was scanned and cleared by NetIQ MailMarshal. ###################################################################### ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users