import base oracle in qvd errors with fields '000001' and '000000001' just one in qvd

[#1]

when i'm create a qvd in SQL SELECT i try to execute 'Text(field)' qliview send me an errors but it's neccesary to have the two lines in my qvd

'000001'

'000000001'

thanks for reply

best regards

Patrice

[#2 · Accepted solution]

All you need to do is:

Load text(FIELD) as FIELD

SQL

select FIELD from table

[#3]

yes i try this but for import direct to oracle base you not nead

load but

Itmmaster:

SQL SELECT

text(ITMREF_0)

as articl

FROM

PRODEF.ITMMASTER

store

Itmmaster into c:\QlikView\Data\Sap\itmmaster1.qvd;

and the system return an error:SQL Error:[Oracle][ODBC][Ora]ORA-00904: "TEXT": invalid identifier

SQL Scriptline:
SQL State:S0022
thanks

[colinh]

Patrice,

Have you tried to_char(ITMREF_0) ?

[#5]

Yes I try but it's not possible

thanks