deployX
09-14-2011, 12:35 PM
I am using Installshield to create my MSI. I want to change datatype of DestName column in DuplicateFile table to nchar. By default Installsheild creates this column as L(255).
I wrote a small VBscript to do this but it fails with Error: openview,sql Code: 80004005 Source: Msi API Error.
It says problem is in statement Set View = DB.OpenView(query)
Following is my vbscript:
Set fso = CreateObject("Scripting.FileSystemObject")
Dim FS, TS, WI, DB, View, Rec
Set WI = CreateObject("WindowsInstaller.Installer")
Set DB = WI.OpenDatabase("MyMSI.msi",1)
query="ALTER TABLE DuplicateFile MODIFY DuplicateFile.DestName nchar(255)"
Set View = DB.OpenView(query)
View.Execute
View.Close
DB.Commit
I did some googling but it didn't help.
Any help would be appreciated.
Also, Is there another way to change datatypes from inside installshield itself?
I wrote a small VBscript to do this but it fails with Error: openview,sql Code: 80004005 Source: Msi API Error.
It says problem is in statement Set View = DB.OpenView(query)
Following is my vbscript:
Set fso = CreateObject("Scripting.FileSystemObject")
Dim FS, TS, WI, DB, View, Rec
Set WI = CreateObject("WindowsInstaller.Installer")
Set DB = WI.OpenDatabase("MyMSI.msi",1)
query="ALTER TABLE DuplicateFile MODIFY DuplicateFile.DestName nchar(255)"
Set View = DB.OpenView(query)
View.Execute
View.Close
DB.Commit
I did some googling but it didn't help.
Any help would be appreciated.
Also, Is there another way to change datatypes from inside installshield itself?