Click to See Complete Forum and Search --> : apawaskar


apawaskar
September 3rd, 2001, 04:05 AM
I am connecting to Oracle table using Microsoft ODBC Driver. I am able to add new records, update , delete it. But I am not able to add new record or update it when the field is number with precision(like number(10,2)). I am using ADODB and recordset objects, addNew method and Update method of the recordset object.
Can anyone find me a solution for this ? It will be a great help to me.

berta
September 3rd, 2001, 08:22 AM
what's the error U have?
how the code U use?



<center>
<HR width=80%>
<img src='http://web.tiscali.it/bertaplanet/images/bertaplanet.gif'>
</center>

Robert Moy
September 3rd, 2001, 11:50 AM
Hello:

How did you setup the Oracle table or how did you enter the data? I am able to add numbers with decimals through VB. My table has a field called salary number(10,2).

Good Luck