I'm try another way: add new component , but received the same results. SQLString worked, SQLScript doesn't. What do you think? Version 1.0.0.0 WXS: ------------------------------------------------------------------------------------------------------------------------------------ <?xml version="1.0" encoding="utf-8"?> <Wix xmlns="http://schemas.microsoft.com/wix/2006/wi"; xmlns:sql="http://schemas.microsoft.com/wix/SqlExtension";> <?define ProductVersion = "1.0.0.0" ?> <Product Id="99458CBE-2934-406A-A51A-4B7C3B6CD4B7" Language="1049" Manufacturer="ELSY" Name="DBUpdate" Version="$(var.ProductVersion)" UpgradeCode="B2BD256D-4E28-47D2-8CDC-E99F69D07CFB"> <Package Compressed="yes" InstallerVersion="300" Languages="1049" /> <Media Id="1" Cabinet="disk1.cab" EmbedCab="yes" CompressionLevel="high" /> <Directory Id="TARGETDIR" Name="SourceDir"> </Directory> <DirectoryRef Id="TARGETDIR"> <Component Id="DBCreate" Guid="64C1581E-6725-4C97-AE16-0275B27AC946"> <sql:SqlScript Id="crVer1" BinaryKey="ver1.sql" ExecuteOnInstall="yes" ExecuteOnReinstall="no" ExecuteOnUninstall="no" SqlDb="oblDB" Sequence="101" /> </Component> </DirectoryRef> <Feature Id="FullInstall" Level="1" Display="expand" Absent="disallow" InstallDefault="local" TypicalDefault="install" AllowAdvertise="no"> <ComponentRef Id="DBCreate" /> </Feature> <InstallExecuteSequence> <RemoveExistingProducts After="InstallFinalize" /> <InstallValidate Sequence="1400" /> </InstallExecuteSequence> <InstallUISequence> <LaunchConditions Sequence="100" /> <FindRelatedProducts Sequence="99" /> <ValidateProductID Sequence="700" /> <CostInitialize Sequence="800" /> <FileCost Sequence="900" /> <CostFinalize Sequence="1000" /> <ExecuteAction Sequence="1300" /> </InstallUISequence> <UI /> <sql:SqlDatabase Id="oblDB" Server="localhost\SQLEXPRESS" Database="obl" /> <Binary Id="ver1.sql" SourceFile="actions\ver1.sql" /> </Product> </Wix> ------------------------------------------------------------------------------------------------------------------------------------ Version 1.0.1.0 WXS (it's work): ------------------------------------------------------------------------------------------------------------------------------------ <?xml version="1.0" encoding="utf-8"?> <Wix xmlns="http://schemas.microsoft.com/wix/2006/wi"; xmlns:sql="http://schemas.microsoft.com/wix/SqlExtension";> <?define ProductVersion = "1.0.1.0" ?> <Product Id="99458CBE-2934-406A-A51A-4B7C3B6CD4B7" Language="1049" Manufacturer="ELSY" Name="DBUpdate" Version="$(var.ProductVersion)" UpgradeCode="B2BD256D-4E28-47D2-8CDC-E99F69D07CFB"> <Package Compressed="yes" InstallerVersion="300" Languages="1049" /> <Media Id="1" Cabinet="disk1.cab" EmbedCab="yes" CompressionLevel="high" /> <Directory Id="TARGETDIR" Name="SourceDir"> </Directory> <DirectoryRef Id="TARGETDIR"> <Component Id="DBCreate" Guid="64C1581E-6725-4C97-AE16-0275B27AC946"> <sql:SqlScript Id="crVer1" BinaryKey="ver1.sql" ExecuteOnInstall="yes" ExecuteOnReinstall="no" ExecuteOnUninstall="no" SqlDb="oblDB" Sequence="101" /> </Component> <Component Id="DBUpdate" Guid="9A71A701-BE6F-400F-A851-E7675865200A"> <sql:SqlString Id="itswork" SQL="ALTER VIEW DB_VER AS SELECT DB_VER=2" Sequence="102" ExecuteOnInstall="yes" ExecuteOnReinstall="yes" SqlDb="oblDB" /> </Component> </DirectoryRef> <Feature Id="FullInstall" Level="1" Display="expand" Absent="disallow" InstallDefault="local" TypicalDefault="install" AllowAdvertise="no"> <ComponentRef Id="DBCreate" /> <ComponentRef Id="DBUpdate" /> </Feature> <InstallExecuteSequence> <RemoveExistingProducts After="InstallFinalize" /> <InstallValidate Sequence="1400" /> </InstallExecuteSequence> <InstallUISequence> <LaunchConditions Sequence="100" /> <FindRelatedProducts Sequence="99" /> <ValidateProductID Sequence="700" /> <CostInitialize Sequence="800" /> <FileCost Sequence="900" /> <CostFinalize Sequence="1000" /> <ExecuteAction Sequence="1300" /> </InstallUISequence> <UI /> <sql:SqlDatabase Id="oblDB" Server="localhost\SQLEXPRESS" Database="obl" /> <Binary Id="ver1.sql" SourceFile="actions\ver1.sql" /> </Product> </Wix> ------------------------------------------------------------------------------------------------------------------------------------ Version 1.0.1.0 WXS (it's not work): ------------------------------------------------------------------------------------------------------------------------------------ <?xml version="1.0" encoding="utf-8"?> <Wix xmlns="http://schemas.microsoft.com/wix/2006/wi"; xmlns:sql="http://schemas.microsoft.com/wix/SqlExtension";> <?define ProductVersion = "1.0.1.0" ?> <Product Id="99458CBE-2934-406A-A51A-4B7C3B6CD4B7" Language="1049" Manufacturer="ELSY" Name="DBUpdate" Version="$(var.ProductVersion)" UpgradeCode="B2BD256D-4E28-47D2-8CDC-E99F69D07CFB"> <Package Compressed="yes" InstallerVersion="300" Languages="1049" /> <Media Id="1" Cabinet="disk1.cab" EmbedCab="yes" CompressionLevel="high" /> <Directory Id="TARGETDIR" Name="SourceDir"> </Directory> <DirectoryRef Id="TARGETDIR"> <Component Id="DBCreate" Guid="64C1581E-6725-4C97-AE16-0275B27AC946"> <sql:SqlScript Id="crVer1" BinaryKey="ver1.sql" ExecuteOnInstall="yes" ExecuteOnReinstall="no" ExecuteOnUninstall="no" SqlDb="oblDB" Sequence="101" /> </Component> <Component Id="DBUpdate" Guid="9A71A701-BE6F-400F-A851-E7675865200A"> <sql:SqlScript Id="isnotwork" BinaryKey="ver3.sql" SqlDb="oblDB" ExecuteOnInstall="yes" ExecuteOnReinstall="yes" Sequence="103" /> </Component> </DirectoryRef> <Feature Id="FullInstall" Level="1" Display="expand" Absent="disallow" InstallDefault="local" TypicalDefault="install" AllowAdvertise="no"> <ComponentRef Id="DBCreate" /> <ComponentRef Id="DBUpdate" /> </Feature> <InstallExecuteSequence> <RemoveExistingProducts After="InstallFinalize" /> <InstallValidate Sequence="1400" /> </InstallExecuteSequence> <InstallUISequence> <LaunchConditions Sequence="100" /> <FindRelatedProducts Sequence="99" /> <ValidateProductID Sequence="700" /> <CostInitialize Sequence="800" /> <FileCost Sequence="900" /> <CostFinalize Sequence="1000" /> <ExecuteAction Sequence="1300" /> </InstallUISequence> <UI /> <sql:SqlDatabase Id="oblDB" Server="localhost\SQLEXPRESS" Database="obl" /> <Binary Id="ver1.sql" SourceFile="actions\ver1.sql" /> <Binary Id="ver3.sql" SourceFile="actions\ver3.sql" /> </Product> </Wix> ------------------------------------------------------------------------------------------------------------------------------------ Patch WXS: ------------------------------------------------------------------------------------------------------------------------------------ <?xml version="1.0" encoding="utf-8"?> <Wix xmlns="http://schemas.microsoft.com/wix/2006/wi";> <Patch AllowRemoval="yes" Manufacturer="ELSY" DisplayName="Sample Patch" Description="Small Update Patch" Classification="Service Pack" Codepage="1252"> <Media Id="5000" Cabinet="RTM.cab"> <PatchBaseline Id="RTM"> </PatchBaseline> </Media> <PatchFamilyRef Id="SamplePatchFamily" /> </Patch> <Fragment> <PatchFamily Id="SamplePatchFamily" Version="1.0.0.0" Supersede="no"> <ComponentRef Id="DBCreate" /> <ComponentRef Id="DBUpdate" /> </PatchFamily> </Fragment> </Wix> ------------------------------------------------------------------------------------------------------------------------------------
> Victor V. Sergeev wrote: >> > Yes, I'm adding new elements to existing component. >> > >> > > You can't do that in a minor upgrade/patch; it violates component rules, > which state that components are immutable. > ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
