This question is a usage question and belongs on wix-users instead of wix-devs.
Short answer: <?define?> creates variables of the $(var.varname) style, so you would use: CREATE TABLE $(var.tablename) (Value1 CHAR(50), Value2 INTEGER) as your query string with the SqlString element. Blair -----Original Message----- From: Nageswara [mailto:nag_mittapa...@yahoo.com] Sent: Thursday, November 24, 2011 2:33 AM To: wix-devs@lists.sourceforge.net Subject: [WiX-devs] Replace SQL Variable using WIX in SQL Script Hi Team, I have SQL Script and executing that script as part of MSI Intallation using WIX Tool. Now I would like to declare a variable in the script and want to replace the variable value from Include file variable value. Script: CREATE TABLE $(tablename) (Value1 CHAR(50), Value2 INTEGER) Include.wxi <?define tablename = "Test" ?> Now I want to replace the $(tablename) value with Test which is declared in Include file. can you help me how can I achive this My requirment is to declare a variable in sql script file and variable value should replace with WIX Tool. Please help me with resolution -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Replace-SQL-Va riable-using-WIX-in-SQL-Script-tp7027655p7027655.html Sent from the wix-devs mailing list archive at Nabble.com. ---------------------------------------------------------------------------- -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-novd2d _______________________________________________ WiX-devs mailing list WiX-devs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-devs ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-novd2d _______________________________________________ WiX-devs mailing list WiX-devs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-devs
