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  ?

 

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.
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

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"

 

Answered 10/23/2012 by: captain_planet
Second Degree Brown Belt

  • Owo my Good you did it ! Thanks
Please log in to comment
1

Go through my tutorials here:

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

You failed at Golden Rule number 3! :-)

Answered 10/23/2012 by: captain_planet
Second Degree Brown Belt

Please log in to comment

  • This content is currently hidden from public view.
    Reason: Removed by user request
    For more information, visit our FAQ's.
  • This content is currently hidden from public view.
    Reason: Removed by user request
    For more information, visit our FAQ's.
Please log in to comment
Answer this question or Comment on this question for clarity