Since you can use a formatted property successfully for the Database attribute of a sql:Database element, why aren't you either: 1) placing your sql:SqlScript elements as children of the sql:Database element being created; or 2) using a sql:Database element outside of a Component as a "locator" element and then referencing the sql:Database from your sql:Script elements?
-- John Merryweather Cooper Build & Install Engineer - ESA Jack Henry & Associates, Inc.® Shawnee Mission, KS 66227 Office: 913-341-3434 x791011 jocoo...@jackhenry.com www.jackhenry.com -----Original Message----- From: Yankulin, Leonid [mailto:leonid.yanku...@mckesson.com] Sent: Wednesday, August 13, 2014 3:38 AM To: wix-users@lists.sourceforge.net Subject: [WiX-users] Cannot set SqlDb to property value Hello, I am trying to run SQL script on existing database. I have SqlDatabase element that is defined under Fragment element. I also have a Property element that is defined in the same Fragment and as value has a Id of the SqlElement. Now, I want to use this property as a value for @SqlDb of the SqlScript element. I define smth. like: <sql:SqlScript Id='SqlCreateView' BinaryKey='SqlCreateView' SqlDb="[SQLDB_ID]" ExecuteOnInstall='yes' /> where SQLDB_ID is a property id defined as: <Property Id="SQLDB_ID">SqlDatabase.IntegratedAuthentication</Property> The compilation results in: error LGHT0094: Unresolved reference to symbol 'SqlDatabase:[SQLDB_ID]' in section 'Fragment:'. Indeed there is no SqlDatabase element with Id = [SQLDB_ID], but I expected from WiX to take a value of the property. Any advise? Leonid ------------------------------------------------------------------------------ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users NOTICE: This electronic mail message and any files transmitted with it are intended exclusively for the individual or entity to which it is addressed. The message, together with any attachment, may contain confidential and/or privileged information. Any unauthorized review, use, printing, saving, copying, disclosure or distribution is strictly prohibited. If you have received this message in error, please immediately advise the sender by reply email and delete all copies. ------------------------------------------------------------------------------ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
