Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 32387 invoked from network); 26 Aug 2009 01:33:38 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 26 Aug 2009 01:33:38 -0000 Received: (qmail 98464 invoked by uid 500); 26 Aug 2009 01:34:03 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 98413 invoked by uid 500); 26 Aug 2009 01:34:03 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 98405 invoked by uid 99); 26 Aug 2009 01:34:03 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 26 Aug 2009 01:34:03 +0000 X-ASF-Spam-Status: No, hits=-4.0 required=10.0 tests=RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [192.18.6.24] (HELO gmp-eb-inf-2.sun.com) (192.18.6.24) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 26 Aug 2009 01:33:51 +0000 Received: from fe-emea-10.sun.com (gmp-eb-lb-1-fe1.eu.sun.com [192.18.6.7] (may be forged)) by gmp-eb-inf-2.sun.com (8.13.7+Sun/8.12.9) with ESMTP id n7Q1XUYS025453 for ; Wed, 26 Aug 2009 01:33:30 GMT MIME-version: 1.0 Content-transfer-encoding: 7BIT Content-type: text/plain; CHARSET=US-ASCII Received: from conversion-daemon.fe-emea-10.sun.com by fe-emea-10.sun.com (Sun Java(tm) System Messaging Server 7u2-7.04 64bit (built Jul 2 2009)) id <0KOY00500MUPGW00@fe-emea-10.sun.com> for derby-user@db.apache.org; Wed, 26 Aug 2009 02:33:23 +0100 (BST) Received: from khepri23.norway.sun.com ([unknown] [129.159.112.235]) by fe-emea-10.sun.com (Sun Java(tm) System Messaging Server 7u2-7.04 64bit (built Jul 2 2009)) with ESMTPSA id <0KOY00MEAMZNKP70@fe-emea-10.sun.com> for derby-user@db.apache.org; Wed, 26 Aug 2009 02:33:23 +0100 (BST) Date: Wed, 26 Aug 2009 03:33:22 +0200 From: Dag.Wanvik@Sun.COM (Dag H. Wanvik) Subject: Re: problem: column values in database are not saved In-reply-to: <25129010.post@talk.nabble.com> Sender: Dag.Wanvik@Sun.COM To: Derby Discussion Message-id: References: <25129010.post@talk.nabble.com> User-Agent: Gnus/5.1008 (Gnus v5.10.8) Emacs/22.1 (usg-unix-v) X-Virus-Checked: Checked by ClamAV on apache.org anna_a writes: > has data type decimal and precision 3. If i for example want to change a > value from 1 to 0.5 I type in 0.5 and then press the "commit > record(s)"button. So far so good, it looks like everything's been saved like Anna, it seems as if you are seeing this from an application or IDE, since Derby doesn't have GUI buttons. I think you will need to provide some more information before we can help you. Derby does allow you to trace the SQL being executed, though, cf. http://db.apache.org/derby/docs/10.5/ref/rrefproper43517.html Dag > i wanted it to. Now to the problem: if I choose to insert a new record the > decimal value I'd entered disappears and is replaced with the previous > integer (1 in this case). This only happens if i've updated the table by > entering a new decimal value, not if the new correlation is an integer like > 0 for example. Does anyone know what i'm doing wrong? > > > > Kind regards, > > Anna > -- > View this message in context: http://www.nabble.com/problem%3A-column-values-in-database-are-not-saved-tp25129010p25129010.html > Sent from the Apache Derby Users mailing list archive at Nabble.com. >