[AccessD] Comma Decimal separator in UPDATE query

Solved with(the Price have 2 decmial places):
DoCmd.RunSQL "Update tblOrderDetail set price=" & (NewPrice*100) & " where
OrderNo=" & Order & " and ProductNo=" & Product
DoCmd.RunSQL "Update tblOrderDetail set price=Price/100 where OrderNo=" &
Order & " and ProductNo=" & Product
Ervin

----- Original Message -----
From: "Ervin Brindza" <viner at EUnet.yu>
To: <AccessD at databaseadvisors.com>
Sent: 18 August, 2004 10:33 AM
Subject: [AccessD] Comma Decimal separator in UPDATE query


> Hi,
> I have a comma decimal separator and it isn't work in Update query. I want
to open the Products form from "Order Details"(subform), modify the price,
and get that new price on the subform. How can I force the Update query to
accept it?
> My query looks like:
> DoCmd.RunSQL "Update tblOrderDetail set price=" & NewPrice & " where
OrderNo=" & Order & " and ProductNo=" & Product
> Many thanks in advance
>     Ervin
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>