Forums

This topic is locked

Weird Number Formatting problem + Update

Posted 16 Dec 2001 21:49:24
1
has voted
16 Dec 2001 21:49:24 e site posted:
Hi

I'm building an e-comm site in Access+UD (Europe) but we host in the US.

I have two weird things.
If I update numbers they are multiplied by 10 when I use Update RS.
This *only* happens when the number has a value after the comma??!!

Secondly, I 've been forced to Use Charon's Update, since the regular MM Update RS causes an "500" error ?!

I've already set the Locale ID to '2065' ...

Any clue ?

thanx
e_site

Replies

Replied 17 Dec 2001 17:50:55
17 Dec 2001 17:50:55 Joel Martinez replied:
hmm, for one, I don't think sql would like a comma in a number... is that how it's going into the sql statement?

how exactly are you trying to update the records?

Joel Martinez [ ]
----------
E-Commerce Concepts with Ultradev...pre-order yours at
www.basic-ultradev.com/ecomm_concepts/

Reply to this topic