System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: 2191d6ca2f51eeda230a65991359bbf728041c23
Title: Error by "create unique index" with "SQLiteCommand.ExecuteNonQuery()"
Status: Closed Type: Incident
Severity: Important Priority: Medium
Subsystem: Integration_Via_PInvoke Resolution: Works_As_Designed
Last Modified: 2013-04-29 22:29:23
Version Found In: 1.0.84.0
User Comments:
anonymous added on 2013-04-26 07:36:19: (text/x-fossil-plain)
Hello,

i create a new *.db3 with Table "punkte" that all runs perfectly.
But after this i can't create a index with SQLiteCommand.ExecuteNonQuery().
The return is "0" and no create the index. The curios is when i do this on
database.net (freeversion) with SQL-query and exactly sam commandtext
runs without error and make the index
SQL for create Table

create table Punkte(punktnummer varchar(50) NOT NULL,rechtswert real,hochwert real,hoehe real,code varchar(10),projektname varchar(20));

SQL for create Index

CREATE UNIQUE INDEX UQ_Punkte_punktnummer ON Punkte(punktnummer);

regards Mario

mistachkin added on 2013-04-26 07:42:14: (text/x-fossil-plain)
I'm unable to reproduce the issue described here locally.  Do you have some C# 
example code that demonstrates the issue you are seeing?

anonymous added on 2013-04-26 08:10:00: (text/x-fossil-plain)
Hello,

i have for test ignore the return value "0" from ExecuteNonQuery() and have
this commited and it works.
I have think that the return value fom ExecuteNonQuery is on non (upd, ins, del)
always ok "-1".

Thanks
"over and out"
Mario