Update query on CreateFolder table is not working
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:
0 Comments
[ - ] Hide Comments
Comments
log in to commentAnswer Chosen by the Author
Answers
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_.
Please log in to comment
Reason: Removed by member request
For more information, visit our FAQ's.