I found the discussion in this topic useful in developing my major upgrade. I do not want my old version of the product to be removed after installing the patch and hence, i did as per Stefan's suggestion (adding 2 to attribute value 769). By doing this, I expected the patch install to patch the files and leave the old version of the product as it is. But the result was different. Though it didnot uninstall the old version of the product, it didnt patch the files as well. My upgrade table is:
Upgrade code - 6.0 - (empty version max) - 1033 - 771 - (empty Remove column) - [DETECTEDPRODUCTS]
Also i have made sure that
1) Product version is changed
2) Product Code is changed
3) Upgrade Code is the SAME
4) SecureCustomProperties assigned to DETECTEDPRODUCTS
5) Added a property DETECTEDPRODUCTS
6) Package Code changed.
Am i missing something here? Urgent.... Please help.
Thanks.