I need your help in one of my question. When I update my user defined form having matrix in it, I generally get an error that 'This Entry already Exist'. I discussed this problem with one of my friend & he suggested me that I should delete the matrix data first & then try to update. He gave me a solution something like this :
Delete From ChildTableName Where code = 'AnyCode'
But I have read somewhere that we should not do that Delete & update by query. But I have seen in SDK help samples to use the Update query in Blanket agreement sample. So can you please tell me whether it is right to use this query in this way or not.
Else tell me if there is something else through which I can delete the matrix data first & my database also does not get corrupted. I want to delete the matrix data because through this I am able to update properly.
Please give your valueable suggestion.