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