Обсуждение: cannot insert zero in to numeric field

i am usig postgres with VB (ADO using ODBC). when i
try to update a numeric field in a table with zero an
error occurs "ERROR: Bad numeric input format '.' " .
this happends when i call recordset.update() after
assigning 0 to the field. a sample is given bellow

rs!Opening=0 
rs.Update

this code works fine if we assign any value other than
zero to the field.is there a solution. or is it a bug?

if i use the update query there is no problem.

pls help

thanks...



__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com