It was the length of the string in second 'Value' column - it must be at most
255 characters.
-----Original Message-----
From: Tony Juricic
Sent: Tuesday, September 01, 2009 2:09 PM
To: wix-users@lists.sourceforge.net
Subject: [WiX-users] Creating database table via DTF - SQL syntax
This is probably not DTF specific issue. I have code to add a table to MSP file:
using (Database db = new Database(file, DatabaseOpenMode.Transact))
{
ColumnInfo[] arrc = new ColumnInfo[2]
{
new ColumnInfo("Key", typeof(string), 32, true),
new ColumnInfo("Value", typeof(string), 256, false)
};
List<string> pk = new List<string>() { "Key" };
TableInfo ti = new TableInfo("_MyTable", arrc, pk);
db.Tables.Add(ti);
db.Commit();
}
This code throws exception:
Microsoft.Deployment.WindowsInstaller.BadQuerySyntaxException: SQL query syntax
invalid or unsupported. Database:
Invalid or missing query string: CREATE TABLE `_MyTable` (`Key` CHAR(32) NOT
NULL, `Value` CHAR(256) PRIMARY KEY `Key`).
My problem is that I am unable to see what is wrong with this query. It seems
fine according to this spec:
http://msdn.microsoft.com/en-us/library/aa372021(VS.85).aspx
TradeStation Group, Inc. is a publicly-traded holding company (NASDAQ GS: TRAD)
of three operating subsidiaries, TradeStation Securities, Inc. (Member NYSE,
FINRA, SIPC and NFA), TradeStation Technologies, Inc., a trading software and
subscription company, and TradeStation Europe Limited, a United Kingdom,
FSA-authorized introducing brokerage firm. None of these companies provides
trading or investment advice, recommendations or endorsements of any kind. The
information transmitted is intended only for the person or entity to which it
is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you received this in error, please contact
the sender and delete the material from any computer.
TradeStation Group, Inc. is a publicly-traded holding company (NASDAQ GS: TRAD)
of three operating subsidiaries, TradeStation Securities, Inc. (Member NYSE,
FINRA, SIPC and NFA), TradeStation Technologies, Inc., a trading software and
subscription company, and TradeStation Europe Limited, a United Kingdom,
FSA-authorized introducing brokerage firm. None of these companies provides
trading or investment advice, recommendations or endorsements of any kind. The
information transmitted is intended only for the person or entity to which it
is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you received this in error, please contact
the sender and delete the material from any computer.
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
