From mboxrd@z Thu Jan 1 00:00:00 1970 X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me X-Spam-Level: X-Spam-Status: No, score=-0.9 required=5.0 tests=BAYES_00,FORGED_GMAIL_RCVD, FREEMAIL_FROM autolearn=no autolearn_force=no version=3.4.4 X-Google-Thread: a07f3367d7,d654f990612c5da5 X-Google-Attributes: gida07f3367d7,public,usenet X-Google-NewGroupId: yes X-Google-Language: ENGLISH,ASCII-7-bit Received: by 10.224.207.72 with SMTP id fx8mr4589855qab.2.1346415051250; Fri, 31 Aug 2012 05:10:51 -0700 (PDT) Received: by 10.52.91.47 with SMTP id cb15mr1362884vdb.11.1346415051229; Fri, 31 Aug 2012 05:10:51 -0700 (PDT) Path: da15ni4265311qab.0!nntp.google.com!b19no1606qas.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: comp.lang.ada Date: Fri, 31 Aug 2012 05:10:51 -0700 (PDT) In-Reply-To: <85ipbzwdsc.fsf@stephe-leake.org> Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=194.98.77.125; posting-account=6yLzewoAAABoisbSsCJH1SPMc9UrfXBH NNTP-Posting-Host: 194.98.77.125 References: <85ipbzwdsc.fsf@stephe-leake.org> User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: Subject: Re: GNATCOLL SQLite rollback vs cursor From: briot.emmanuel@gmail.com Injection-Date: Fri, 31 Aug 2012 12:10:51 +0000 Content-Type: text/plain; charset=ISO-8859-1 Date: 2012-08-31T05:10:51-07:00 List-Id: It is quite possible that this issue has in fact already been fixed in the development version of GNATCOLL, because now with or without the line that frees the cursor, the result is the same: Insert Ada Lovelace ID => 1 Insert Charles Babbage ID => 2 Insert Ada Lovelace [SQL.ERROR] Failed to execute INSERT INTO Author (First, Last) VALUES ("Ada", "Lovelace") error=columns First, Last are not unique ID => 1 Insert Grace Hopper ID => 3 Note also that we have improved the way we retrieve the error messages from sqlite, since the current one is clearer than just the "constraint error" you are getting. Emmanuel