Re: [sqlite] Error 19 with Caret ^ INSERT

2019-10-06 Thread Keith Medcalf
ehalf Of André Borchert >Sent: Saturday, 5 October, 2019 22:56 >To: sqlite-users@mailinglists.sqlite.org >Subject: [sqlite] Error 19 with Caret ^ INSERT > >Hello, > >in my C# program which uses DllImport for sqlite.dll (3.29) I get Error >19 (SQLITE_CONSTRAINT) with this statement:

Re: [sqlite] Error 19 with Caret ^ INSERT

2019-10-06 Thread Simon Slavin
On 6 Oct 2019, at 5:56am, André Borchert wrote: > The odd thing is that the sql statement works just fine when I use DB Browser > for SQLite. Try the SQLite command line tool. That's written by the team which maintains SQLite itself, and it should give the connonically correct result. If it

[sqlite] Error 19 with Caret ^ INSERT

2019-10-06 Thread André Borchert
Hello, in my C# program which uses DllImport for sqlite.dll (3.29) I get Error 19 (SQLITE_CONSTRAINT) with this statement: INSERT INTO CompanyDetails (RIC) VALUES('AMBEUR.IP^G19') The ^ symbol is part of the text I want to save, its not a filter or so, its just plain text. The odd thing is