Code

Re: Save decimal to an access db (ADO)

leGeneral — Thu, 01 Feb 2007 17:51:09 GMT

So I solved it.

It was not a problem with my access db. The problem was that Access expected a "," instead of a ".".
So I had to use a replace function:

var dblGesamtwert = oSrc.selectSingleNode("my:positionsbetrag").text;
rsUmsatz.Fields("Gesamtwert") = dblGesamtwert.replace(".",",");

Christoph

Re: Save decimal to an access db (ADO)

Shilpa Pitta — Wed, 31 Jan 2007 09:08:21 GMT

Hi,
In the access db make the field size to double and select the format as standard to display the decimal values in the field

Hope this helps you!

Save decimal to an access db (ADO)

leGeneral — Sat, 27 Jan 2007 16:31:08 GMT

I hope someone could help me solving my problem.

I design a form as an access frontend. I use code (Jscript,ADO) to save data into the database. So far so good.

Now I`m trying to save a price and a calculated amount to my db. The price and the amount are formated as decimal and currency. The fields in my db are also formatted as currency. If I try to save a price like 99,99 the result in my db is 9999. It ignores the ",".
If I format the price as text there is no problem an my result in my db is 99,99.
But this is not a satisfying solution cause I need decimal values to calculate the amount.

This is how I assign the price to my recordset:

rsUmsatz.Fields("VK") = oSrc.selectSingleNode("my:vkUms").text;

Any idea?

Christoph