in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine

Bug in designer: ON CONFLICT statements are ignored and reset to "Abort"

Last post 08-04-2009 3:40 PM by Robert Simpson. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 07-29-2009 1:54 AM

    Bug in designer: ON CONFLICT statements are ignored and reset to "Abort"

    Hi I'm not sure if this should be reported in the bugs section: If you open a table in design mode in VS2008 and change the conflict handling algorithm of a unique (primary key) column to anything different than the standard "Abort", save and then reopen the design mode, it's reset to "Abort". Even if the conflict algorithm was set programmatically before (e.g. "ID VARCHAR(31) NOT NULL PRIMARY KEY ON CONFLICT REPLACE"), the designer resets it when saving changes to the table.
    Filed under: , ,
  • 08-04-2009 3:40 PM In reply to

    Re: Bug in designer: ON CONFLICT statements are ignored and reset to "Abort"

    I'll see if I can fix this ... SQLite's schema API doesn't really give me this information, so I have to wing it.

     

Page 1 of 1 (2 items)
Powered by Community Server (Commercial Edition), by Telligent Systems