Install components based on installed version

[CRCInfoSys]

I am creating an update to an installation. The update will be version 1.4. Version 1.2 had a database update that I do not want to run again, but I also want the 1.4 update to be able to update any previous versions.

My database update is done within an Installscript custom action. How can I set a condition on the custom action to only fire if version 1.2 has not already been installed. And if that's not possible, is there a way to find out the installed version in the script?

I'm using a Basic MSI project.

Thanks.

[Christopher_Pai]

Can you just write your database update to detect that it's already been run and not run again?

I.e. ( pseudo code, not real sql )

REM build 1.2 sql changes
if not exist new table
create new table
end if

REM build 1.4 sql changes
if not exist something else
do something else
end if

This is probably the easiest and most scaleable solution to support.