PDA

View Full Version : Is it possible to change Datatype of standard MSI Table



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?