UPDATE is not accepting numbers with comma as decimal point

[giedrius]

Hello,

I have a problem with feeding UPDATE statement with values which are numbers but with comma as decimal point:

CurrentDb.Execute "UPDATE Product " & _
"SET qtty=qtty+" & sqtty

Update works fine if sqtty is a whole number. If it comes to updating with a value sqtty=24,5 it fails.

I would suspect Regional Settings has something to do here, but strangelly equation in code sqtty=sqtty+1 works fine just before Update statement is used.

Any ideas?

Thanks/giedrius

 

[giedrius]

Found the solution here:

http://www.mvps.org/access/queries/qry0015.htm

It really turns to be a problem.

giedrius