Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000

When I user ''OLEDB CONNECT TO [Provider=OraOLEDB.Oracle.1;User ID=fbi_dw;Data Source=mic133] (XPassword is DORLQTRMITccWcBHBDZOXGC);'' to connect oracle .I reload again ,my date has someting error. how to solve it 未命名.JPG

24 Replies

use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000

Hi

While loading data from oracle database, try to use date conversion functions.

Hope that helps

Regards

ASHFAQ

MVP
MVP

use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000

Hi

Something like this:

MyTable:
LOAD Num(MYVALUE) AS MYVALUE

....;

SQL SELECT MYVALUE

FROM MYTABLE;

Wrapping numerical values with NUM will remove the trailiing zeroes which are causing the problem.

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
MVP
MVP

Re: use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000

I presume you're selecting from an Oracle view?

Just use Number format Integer.

- Ralf

Not applicable

use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000

HI

  Please give me some example,,thank you very much!

Regards

wsw19870908

Not applicable

use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000

HI

  Please give me some example,,thank you very much!

Regards

wsw19870908wsw19870908

Not applicable

use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000

HI

  Please give me some example,,thank you very much!

Regards

wsw19870908wsw19870908

MVP
MVP

use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000

Can you upload an example app or the SELECT statement?

- Ralf

Not applicable

Re: use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000

@TIQView - Ralf Becher 编写:

Can you upload an example app or the SELECT statement?

- Ralf

This is an example

MVP
MVP

Re: use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000

Do you know if "FBI_DW"."DIM_CALENDAR" is a table or view?

In the Oracle ODBC setting (haven no OLEDB yet) is an option Bind Number as Float, is this checked?

oracle_odbc.png

In the meantime you can adjust number formats in the QlikView document settings:

integer.png

added second picture

Community Browser