Retrieving a list of all the Properties in the Property Table...
|
|
Dominique Louis
|
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 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 [hidden email] https://lists.sourceforge.net/lists/listinfo/wix-users |
||||||||||||||||
Peter Shirtcliffe
|
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:[hidden email]] 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 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 [hidden email] https://lists.sourceforge.net/lists/listinfo/wix-users SDL PLC confidential, all rights reserved. If you are not the intended recipient of this mail SDL requests and requires that you delete it without acting upon or copying any of its contents, and we further request that you advise us. SDL PLC is a public limited company registered in England and Wales. Registered number: 02675207. Registered address: Globe House, Clivemont Road, Maidenhead, Berkshire SL6 7DY, UK. ------------------------------------------------------------------------------ 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 [hidden email] https://lists.sourceforge.net/lists/listinfo/wix-users |
||||||||||||||||
|
Dominique Louis
|
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:[hidden email]] 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:[hidden email]] 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 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 [hidden email] https://lists.sourceforge.net/lists/listinfo/wix-users SDL PLC confidential, all rights reserved. If you are not the intended recipient of this mail SDL requests and requires that you delete it without acting upon or copying any of its contents, and we further request that you advise us. SDL PLC is a public limited company registered in England and Wales. Registered number: 02675207. Registered address: Globe House, Clivemont Road, Maidenhead, Berkshire SL6 7DY, UK. ------------------------------------------------------------------------ ------ 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 [hidden email] https://lists.sourceforge.net/lists/listinfo/wix-users 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 [hidden email] https://lists.sourceforge.net/lists/listinfo/wix-users |
||||||||||||||||
Wilson, Phil
|
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:[hidden email]] 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:[hidden email]] 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:[hidden email]] 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 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 [hidden email] https://lists.sourceforge.net/lists/listinfo/wix-users SDL PLC confidential, all rights reserved. If you are not the intended recipient of this mail SDL requests and requires that you delete it without acting upon or copying any of its contents, and we further request that you advise us. SDL PLC is a public limited company registered in England and Wales. Registered number: 02675207. Registered address: Globe House, Clivemont Road, Maidenhead, Berkshire SL6 7DY, UK. ------------------------------------------------------------------------ ------ 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 [hidden email] https://lists.sourceforge.net/lists/listinfo/wix-users 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 [hidden email] https://lists.sourceforge.net/lists/listinfo/wix-users *** Confidentiality Notice: This e-mail, including any associated or attached files, is intended solely for the individual or entity to which it is addressed. This e-mail is confidential and may well also be legally privileged. If you have received it in error, you are on notice of its status. Please notify the sender immediately by reply e-mail and then delete this message from your system. Please do not copy it or use it for any purposes, or disclose its contents to any other person. This email comes from a division of the Invensys Group, owned by Invensys plc, which is a company registered in England and Wales with its registered office at Portland House, Bressenden Place, London, SW1E 5BF (Registered number 166023). For a list of European legal entities within the Invensys Group, please go to http://www.invensys.com/legal/default.asp?top_nav_id=77&nav_id=80&prev_id=77. You may contact Invensys plc on +44 (0)20 7821 3848 or e-mail [hidden email]. This e-mail and any attachments thereto may be subject to the terms of any agreements between Invensys (and/or its subsidiaries and affiliates) and the recipient (and/or its subsidiaries and affiliates). ------------------------------------------------------------------------------ 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 [hidden email] https://lists.sourceforge.net/lists/listinfo/wix-users |
||||||||||||||||
|
Dominique Louis
|
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:[hidden email]] 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:[hidden email]] 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:[hidden email]] 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:[hidden email]] 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 [hidden email] https://lists.sourceforge.net/lists/listinfo/wix-users |
||||||||||||||||
Blair-2
|
Use the CustomTable element to declare the table, then Column elements to
declare the columns it contains. You can then either use Row/Data elements to insert data, or the EnsureTable element to simply leave an empty table in the MSI file that you populate afterwards. Retrieving data is a straightforward SELECT query. I would think it more straightforward than adding/parsing/regex-ing properties. -----Original Message----- From: Dominique Louis [mailto:[hidden email]] Sent: Friday, October 30, 2009 4:29 AM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Retrieving a list of all the Propertiesin thePropertyTable... 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:[hidden email]] 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:[hidden email]] 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:[hidden email]] 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:[hidden email]] 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 [hidden email] https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ 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 [hidden email] https://lists.sourceforge.net/lists/listinfo/wix-users |
||||||||||||||||
| Free Embeddable Forum Powered by Nabble | Help |
