/build/static/layout/Breadcrumb_cap_w.png

WiRunSql.vbs

Hello,

I would to use the WiRunSql.vbs to modify table msi. I type this command line :

 

C:\>WiRunSQL.vbs test.MSI "UPDATE `File` SET `File`.`Attributes`='16384'  WHERE
`File`.`Attributes`='0'"

The command return :  MSI Error 80004005 1:2232: 2:test.msi 3: 0 4: '"UPDATE `File` SET `File`.`Attributes`='16384'  WHERE `File`.`Attributes`='0'"

The command run without trouble for 

C:\>WiRunSQL.vbs test.MSI "UPDATE `Feature` SET `Feature`.`Title`='Aide' WHERE `
Feature`.`Feature`='Help'"

 

What does mean the  MSI Error 80004005  ?

 


0 Comments   [ + ] Show comments

Answers (3)

Answer Summary:
You need to take the single quotes from around the Integer values. The Attributes column is an Integer datatype, and these don't require single quotes.
Posted by: captain_planet 12 years ago
Black Belt
1

You need to take the single quotes from around the Integer values.  The Attributes column is an Integer datatype, and these don't require single quotes.  I've made an extensive tutorial on this.  I'll post a link shortly....

 Anyway, your SQL should be:

 "UPDATE `File` SET `File`.`Attributes`=16384 WHERE `File`.`Attributes`=0"

 


Comments:
  • Owo my Good you did it ! Thanks - egiberne 12 years ago
Posted by: captain_planet 12 years ago
Black Belt
1

Go through my tutorials here:

http://www.alkanesolutions.co.uk/vbscript_windowsinstaller_tutorials.aspx

You failed at Golden Rule number 3! :-)

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ