Incorrect number

  • Thread starter Thread starter Silviall
  • Start date Start date
S

Silviall

Hi,

I am using vb 2003 .net and oracle. I have a table with 2 fields char and 2
fields double. If I insert a row with a dataadapter and dataset it works
well. But if I update it, it says ORA-01722 number incorrect. But in
parameter it is a double.
(NOTE: I am spanish, can be the difference between ',' and '.'). But if I
change the fields double to char and I update it it says Concurrency
Exception, but the row is correct!!!.

Can you help me???

Thank you.

Silvia.
 
Hi,

Can you post the data that you insert in step 1 & data that you update
(new values) in step 2 ?

Kalpesh
 
Hello Kalpesh

table
empres_cod char(3)
tipent_cod char(4)
carreg number(5,2)
marge number(5,2)
primary key (empres_cod,tipent_cod)

Initial data
'001','AU',2,3 --> Updated --> '001','AU',1,3
I do it with the dataadapter and a textbox binding a dataset.

Thanks for all.
 
Back
Top