Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

oledb oracle connection shows decimals ,00

When I make an oledb connection to an oracle database decimals (,00) are added to numeric values (odbc does not). Is there a possibility to avoid this?

odbc

  • id
  • 01
  • 02
  • 03

oledb

  • id
  • 01,00
  • 02,00
  • 03,00

thanks!

3 Replies
Not applicable

oledb oracle connection shows decimals ,00

I want to avoid this ,too.

Not applicable

Re: oledb oracle connection shows decimals ,00

We encountered this problem ourselves & finally came up with a fix. OLE is much more sensitive to data types than ODBC, so you need to match the format exactly.

http://stackoverflow.com/questions/7920637/convert-a-string-date-into-datetime-in-oracle

I realize this is an old post, but hope it helps somebody.

Not applicable

Re: oledb oracle connection shows decimals ,00

Hi all,

i know this is an old post, but has anyone an solution for this problem.

thanks a lot