I have an MSI that's running a SQL script to insert data (using the SqlScript
wix element). The sql script looks like (simplified somewhat):
/* table: Version */
/* some comment*/
INSERT INTO [dbo].[Version] ([Object],[Version]) VALUES ('mytool',
'2.0.12344.1234')GO
/* some comment*/
INSERT INTO [dbo].[Version] ([Object],[Version]) VALUES ('foo', '2.0.0.1')GO
When I run the MSI, my two records don't get inserted into the table. I've
enabled verbose logging and I don't see any errors:
ExecuteSqlStrings: Executing SQL string: INSERT INTO . (,) VALUES ('mytool,
'2.0.12344.1234')ExecuteSqlStrings: Executing SQL string: INSERT INTO . (,)
VALUES ('azApps', '2.0.0.1')
I have "ContinueOnError=no" in my wix file. I assume the table and column
names are disappearing in the log due to it being a formatted string. I'm also
assuming this isn't happening when actually executing the SQL. This is on wix
3.0.4707.0. I have other MSIs with similar structure that successfully insert
data via SQL script.
Any suggestions on tracking this down?
Thanks,
Kevin
_________________________________________________________________
You live life online. So we put Windows on the web.
http://clk.atdmt.com/MRT/go/127032869/direct/01/
------------------------------------------------------------------------------
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
The future of the web can't happen without you. Join us at MIX09 to help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
