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 Chosen by the Author
Please log in to answer
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