on 12-08-2005 3:51 PM
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
Hi,
since you use decimal places also, change that field to <b>Double</b> in XI and use.I had a similar situation where a numeric field was not at all retreived when i did a JDBC lookup. Hope this solves your problem.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Use a user-defined java function and convert the String field to Numeric field in ur message mapping.
Try this out.
Regards,
Venkataramanan.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Matt,
You better use Numeric field either integer or Long Or double in XI to avoid these confusions..:)
cheers,
Sundararamaprasad.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Matthias,
What error does it give or what was the updated data in that numeric field?
regards,
Felix
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
9 | |
9 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.