Hi all,
  I have a custom dialog that lists all the SQLServer database instances
on the network which take the form
[MachineName]\[SqlInstance] in the dropdown.

On the same form I have a edit box which will hold the full connection
string. What do I need to do so that when the user selects another item
from the combobox, it syncs that combobox value into the Editbox or even
secure property.

At the moment I have the following....

<Control Id="CmbSQLServerInstance" Property="SQLSERVERINSTANCE"
Type="ComboBox" Height="15" Width="140" X="14" Y="93" Text="Ppphhh"
ComboList="yes" ToolTip="The instance of SQL Server you would like to
attach to.">          
          <ComboBox Property="SQLSERVERINSTANCE">
            <ListItem Value="localhost\MSSQLSERVER"/>
            <ListItem Value="localhost\SQLEXPRESS"/>
          </ComboBox>
          <Publish Event="DoAction"
Value="SetConnectionStringVB"><![CDATA[1]]></Publish>
        </Control>

        <Control Id="tbConnectionString" Type="Text" X="14" Y="112"
Width="140" Height="14" Transparent="yes" NoPrefix="yes">
          <Text>Connection String</Text>
        </Control>
        <Control Id="ebConnectionString" Type="Edit" Height="15"
Width="140" X="14" Y="127" Property="SQLCONNECTIONSTRING"  />

And my SetConnectionStringVB looks like this...
<CustomAction Id="SetConnectionStringVB"
                  Script="vbscript"
                  Execute="immediate">
    <![CDATA[      
      Session.Property("SQLCONNECTIONSTRING") = "Data Source=" &
Session.Property("SQLSERVERINSTANCE") & ";Initial
Catalog=AMXDatabase;Integrated Security=True"      
    ]]>
  </CustomAction>

But it seems that the SetConnectionStringVB code is never called from
the combobox's DoAction.
What have I done wrong?


Thanks,


DOMINIQUE LOUIS | IS DEVELOPER, AMX DIGITAL MEDIA GROUP


AMX

AMX UK
Auster Road
Clifton Moor
York, North Yorkshire
United Kingdom
YO30 4GD

+44 (0) 1904 343100     office
+44 (0) 1904 343101     fax

AMX South
6th Floor Salisbury House
London Wall
London
United Kingdom
EC2M 5QQ

+44 (0) 2076 529450     office
+44 (0) 8701 991661     fax

AMX Belgium
Boerenkrijglaan, 96a
B-2260
Westerlo
Belgium


+ 32 (0) 1454 2763      office
+ 32 (0) 1454 2766      fax

######################################################################
Attention: 
This e-mail message is privileged and confidential. If you are not the 
intended recipient please delete the message and notify the sender. 
Any views or opinions presented are solely those of the author.

This email was scanned and cleared by NetIQ MailMarshal.
######################################################################

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users

Reply via email to