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

JDBC: Convert string to NUMERIC

Former Member
0 Likes
414

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

You can get the error from work directory on the server.

Get the sql error, it could be db specific.

I believe there should be no data conversion needed if your inbound interface also defined as xml:float.