Getting ProductVersion from MSI

FinalBuilder Discussion
1

Hi,

I am trying to get the value for the ProductVersion from an MSI.  I have tried to use the MSI Generic action, but all the SQL statements I have tried fail.

I have tried the following:

  • SELECT ProductVersion FROM Property
  • SELECT * WHERE Property='ProductVersion'

Regards

Sean Flook

2

Hi Sean,

Here is the SQL statement that retrieves the ProductVersion from the MSI database.

SELECT Value FROM Property WHERE Property=‘ProductVersion’

Regards,
Paul.

3

Hi Paul,

Thanks for that, it has done the trick nicely

Regards
Sean

4

I tried this to get the version of a previous MSI file so I can create a backup of that file in a directory w/ the version as it's name.

I'm seeing two issues though:

1. Succeeding runs of the action fail because it can't open the MSI file. The first two runs work w/o this error.

2. Once the version is captured into variable, I try to move the MSI file into the version folder, but it fails; says the MSI file is being used by another process.

Now, these two issues seem to denote that there's a file lock existing on the MSI after the query runs.

Got any solution for this? Or a workaround perhaps?

BTW, I'm using FB 6.

 

Thanks!