cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

JDBC: Convert string to NUMERIC

Former Member
0 Likes
413

Hi,

I have to update a database table and so far all fields works find during SQL Update. Only a DB-field type numeric doesn't work. On XI I have a string value.

How should I convert it? Any helps welcome.

THX

Matt

View Entire Topic
Former Member
0 Likes

Matthias,

What error does it give or what was the updated data in that numeric field?

regards,

Felix

Former Member
0 Likes

Hi Felix,

thx for your quick response... no error I just get no acknowledgement back until I deactivate this field. After deactivation it runs...

Its a 10 digit character and the numeric on DB - side its also 10 digit + decimal places.

THX

Matt

Former Member
0 Likes

Matthias,

Does it work for other numeric fields?

regards,

Felix