[WiX-users] removal of comment in sql scripts by using SqlScript
Hello, At this moment scripts that are run during installation are stripped before processing. It is removing comment and spaces before it processes the script. (I checked in source code, this happens in scasqlstr.cpp line 282 and further for version 2.0.5805.0) Is there a good reason for this? I see what is the disadvantage: For instance: When I have a sql script like this: SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON GO -- This is important information CREATE PROCEDURE [dbo].[Test] AS BEGIN END GO Normal the comment in the script will be stored together with the database (you can try it with sp_helptext 'Test') With a wix-created installer this comment is gone. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
[WiX-users] Problem with VS2005
Hello, After not using WIX a while, we made a new release, and now VS2005 is crashing when i want to create a new WIX project. Also opening an old wix project, does not open anything. I already removed and reinstalled votive, but this did not solve the problem. I recently installed also Extensions for Windows WF, and .NET Framework 3.0Development tools as VS2005 plugins. Anyone else who also installed those plugins, but has no problems? Or (better) anyone who know about this problem and knows a workaround? Jaap - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
[WiX-users] How to add sections properly to app.config
Hello, I am using Wix 2.0.5325.0 I have a app.config that I want to modify: configuration applicationSettings TestService.Properties.Settings setting name=Property serializeAs=String valueValue/value /setting setting name=MyProperty serializeAs=String valueMyValue/value /setting /TestService.Properties.Settings /applicationSettings /configuration I want to insert the blue lines. Remark, there are already lines before with the same node names before the inserted lines! I tried the following code in WIX: XmlConfig Id='TestService_Settings_MyProperty' Action='create' Name='setting' File='[_TestService]TestService.exe.config' ElementPath='//configuration/applicationSettings/TestService.Properties.Settings' On=install Node=element Sequence=1 / XmlConfig Id='TestService.Settings.MyProperty.Name' File='[_TestService]TestService.exe.config' Name='name' ElementPath='TestService_Settings_MyProperty' Value=MyProperty Sequence=2 / XmlConfig Id='TestService.Settings.MyProperty.SerializeAs' File='[_TestService]TestService.exe.config' Name='serializeAs' ElementPath='TestService_Settings_MyProperty' Value=String Sequence=2 / XmlConfig Id='TestService_Settings_MyProperty_Value' File='[_TestService]TestService.exe.config' ElementPath='//configuration/applicationSettings/NewBridges.Properties.Settings/[EMAIL PROTECTED]MyProperty[\]]' Action=create Name=value On=install Node=element Sequence='3'/ XmlConfig Id='TestService.Settings.MyProperty.Value.Text' File='[_TestService]TestService.exe.config' ElementPath='Id='TestService_Settings_MyProperty_Value' Value=MyValue Sequence=4 / Now it works as expected until the red lines. I get the message fError 25542. Failed to find node: //configuration/applicationSettings/TestService.Properties.Settings/[EMAIL PROTECTED] MyProperty] in XML file: C:\Program Files\TestService\TestService.exe.config, system error: -2147020584 which is correct, while this node is not yet in the file. However when I leave out the red lines, the node settings name=MyProperty / is created. I also tried the lines below instead of the red lines: XmlConfig Id='TestService.Settings.MyProperty.Value' File='[_TestService]TestService.exe.config' ElementPath='TestService_Settings_MyProperty' Value=valueMyValue/value Sequence=2 / and several other things, but I was not able to create a xml-element with sub-elements in an existing XML file Anyone suggestions? Jaap - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Set Installdir
I do the same , I use After=LaunchConditions, which is about the first possible moment -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Alexander Gnauck Sent: donderdag 10 augustus 2006 10:39 To: wix-users@lists.sourceforge.net Subject: [WiX-users] Set Installdir Hello, i have to set the Installdir directory depending on a registry value. Of course the user can overwrite this default setting in the UI. So i read the path from the registry in a property and assign this property to the installdir property with a custom action. My problem is the sequencing of this custom action. What would be the correct sequence for executing this custom action? Thanks Alex - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
[WiX-users] SqlScript and CustomActions
Hello, I want to create a database, run an sql script to create tables etc. then do a few custom actions, which fill the database, and then execute a few sql strings. The last sql strings contain values which depend on customer choices. My question is: Is there a way of scheduling custom actions between some sql scripts, and some sql strings? Jaap - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
