problem: column values in database are not saved

[anna_a]

Hi all,
I hope someone can give me a pointer or two about how to get around this problem;

in the database that i've created i've got a column called correlation which 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 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

[Melongo Annabel]

Frida,
I would recommend you post this to your db mailing list. As you can see this has nothing to do with NB, you might be luckier there.... Thanks.


From: anna_a <address-removed>
To: address-removed
Sent: Monday, August 24, 2009 5:26:43 AM
Subject: [nbusers] problem: column values in database are not saved

Hi all,

I hope someone can give me a pointer or two about how to get around this problem;



in the database that i've created i've got a column called correlation which 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 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

------------------------
anna