Scripting Question

Update query on CreateFolder table is not working

04/22/2015 1517 views
When I am trying to use update query on CreateFolder table in msi then I am getting runtime exception but it is working fine with other tables.

string value = textBox2.Text.Trim();
database.Execute("Update `CreateFolder` Set `CreateFolder`.`Component_` = '" + value + "'");
Answer Summary:
0 Comments   [ + ] Show comments


  • This content is currently hidden from public view.
    Reason: Removed by member request For more information, visit our FAQ's.

Answer Chosen by the Author

Not like traditional databases, In MSI file we can't update a primary key with update query.In CreateFolder table, both Directory_ and Component_ are primary keys.

So, the approach I followed now is to read the complete row and delete it and create again with new value of Component_.
Answered 04/24/2015 by: ur00361883
Black Belt

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