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();
MessageBox.Show(value);
database.Execute("Update `CreateFolder` Set `CreateFolder`.`Component_` = '" + value + "'");
Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

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

0
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
Third Degree Brown Belt

Please log in to comment

Answers

Answer this question or Comment on this question for clarity
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja

Share