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   [ - ] Hide Comments


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

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
Fifth Degree Brown Belt

Please log in to comment
Answer this question or Comment on this question for clarity