1 reply to this topic

[Amarjeet]

HI

I am trying to create a condition which will check installed version of SQL 2005 Express edition.

Following registry key has version information in integer form.

SOFTWARE\Microsoft\Microsoft SQL Server\SQLEXPRESS\MSSQLServer\CurrentVersion\Currentversion.

For current version its 9.00.5000.00

Now i want to make sure that new SQL server 2008 R2 ( version - 10.00.1600.1) should not overwrite my previous version.

When i try to compare 10.00.1600 with the version stored in registry it does not work.

I tried SQL2005VER<<"10.00.1600" so that first digit will be compared. But thid does not work as well ( since i am trying to copare a string with integer value in registry)

Any clue ?

Amarejeet

[Stefan Krueger]

MSi has no numeric compare functionality, only string compare, so you would have to create a custom action for this purpose.
Or maybe you can use Installshield's prerequiste functionality?