> -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of RSmith > Sent: Friday, May 09, 2014 2:01 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] duplicate row in sqlite3 database > > That sounds NOTHING like a violation error... it seems a lot more like > the intermediate thing failed on communicating, but I am not familiar > with it (I hope another poster might have advice) - unless it simply > does not understand the serialized output. Either way it doesn't feel > right to me.
It only happens when I try it insert a duplicate row, otherwise things are working very well. It doesn't feel right to me either, but this is not unusual for VEE. VEE is a large interpreted environment. There is so much going on between the user and the cpu that error codes are sometimes obfuscated to the point that you see here. I just have to assume that an error on INSERT is due to a duplicate row. There's nothing else I can do. > > > On 2014/05/09 19:52, Drago, William @ MWG - NARDAEAST wrote: > > When I deliberately try to insert a duplicate row I get the following > error from my VEE* environment: > > > > Execution of method ExecuteNonQuery in the referenced .NET object or > type failed. > > Exception type: System.Runtime.Serialization.SerializationException > > Type is not resolved for member 'System.Data.SQLiteException, > System.Data.Sqlite, Version=1.0.92...' > > > > If that sounds like a duplicate row error, I'll trap it and display a > message to the user. > > > > -Bill > > > > *About VEE: > > http://cp.literature.agilent.com/litweb/pdf/5990-9117EN.pdf > > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any attachments are solely for the use of the addressee and may contain information that is privileged or confidential. Any disclosure, use or distribution of the information contained herein is prohibited. In the event this e-mail contains technical data within the definition of the International Traffic in Arms Regulations or Export Administration Regulations, it is subject to the export control laws of the U.S.Government. The recipient should check this e-mail and any attachments for the presence of viruses as L-3 does not accept any liability associated with the transmission of this e-mail. If you have received this communication in error, please notify the sender by reply e-mail and immediately delete this message and any attachments. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users