Ticket Hash: | 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 |