8 replies to this topic

[angp]

Hi,

Anyone has any idea how to use the WiRunSQL.vbs script to drop a column in the MSI table?

I have read the MS website but still have no idea how to go about it.
Any example will be appreciated.


Thanks,
angp

[luke_s]

Why do you need to drop a column?

Or do you mean a row?

[Glytzhkof]

It sounds strange to drop a column from a table - this is kind of a database structure / schema change. Are you sure this is what you want to do?

[Stefan Krueger]

I don't think you can drop columns, only rows.

[Zweitze]

Orca can delete columns, at least from custom tables (context menu of table, "edit schema" or something like that). Maybe it deletes records from the Columns_ table.
I'm curious what you want to achieve though?

[Glytzhkof]

If you delete a column from an MSI file you could remove a column that is used as a foreign key into another table. This will break the database integrity and consistency. I also think you can corrupt the _Validation table by deleting stuff rom your MSI file. I am sure there is plenty more that can break.

[angp]

Hi All,

The reason why i'm asking for dropping a column is because i have a 3rd party MSI project that uses older version of WISE. Whenever i need to merge my MSI changes with the 3rd party there is a table that having mismatch column. The WiseRelease table.

i thou of having a cleaner way of automating the process of fixing the table to be of the same column as the 3rd party.

regards,
angp

[Stefan Krueger]

Does that table have any meaning in the built MSI file at all? Otherwise you could just drop the table.
Also I think you can ADD columns.

[Glytzhkof]

I am pretty sure you can drop all wise tables from the MSI without causing serious problems. You may get some issues with the _Validation table.

The stuff you will lose is stuff such as source paths, release settings etc...