use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000

[#1]

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

[ashfaq_haseeb]

Hi

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

Hope that helps

Regards

ASHFAQ

[jonathandienst]

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

[rbecher]

I presume you're selecting from an Oracle view?

Just use Number format Integer.

- Ralf

[#5]

HI

  Please give me some example，，thank you very much！

Regards

wsw19870908

[#6]

HI

  Please give me some example，，thank you very much！

Regards

wsw19870908wsw19870908

[#7]

HI

  Please give me some example，，thank you very much！

Regards

wsw19870908wsw19870908

[rbecher]

Can you upload an example app or the SELECT statement?

- Ralf

[#9]

@TIQView - Ralf Becher 编写:

Can you upload an example app or the SELECT statement?

- Ralf

This is an example

[rbecher]

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?

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

added second picture