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

Reply via email to