Update query on CreateFolder table is not working

  • ur00361883
    Fourth Degree Brown Belt
  • How helpful is this to you?
  • Average Rating 0
  • 922 views
  • 04/22/2015
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
Fourth Degree Brown Belt

Please log in to comment

Answers

Answer this question or Comment on this question for clarity