I'm trying to retrieve data from the table tdinv750. I'm using a odbc connection but it's generating a error message. The message points out that the field aupp cannot be accessed or found. When i'm looking into the table with the session ttaad4500 the field aupp has multiple values. How can i access this data. Could somebody explain how the table is created or designed in order to solve the problem?

Thanks - Dirk

Since you are using oracle, you have to specify the field name as it exist in the database. Below is a list of the fields you have to specify. NOTE that their are 13 fields for AUPP in the database.

T$ITEM NOT NULL CHAR(16
T$CNTR NOT NULL CHAR(3)
T$YEAR NOT NULL NUMBER
T$AUPP$1 NOT NULL NUMBER
T$AUPP$2 NOT NULL NUMBER
T$AUPP$3 NOT NULL NUMBER
T$AUPP$4 NOT NULL NUMBER
T$AUPP$5 NOT NULL NUMBER
T$AUPP$6 NOT NULL NUMBER
T$AUPP$7 NOT NULL NUMBER
T$AUPP$8 NOT NULL NUMBER
T$AUPP$9 NOT NULL NUMBER
T$AUPP$10 NOT NULL NUMBER
T$AUPP$11 NOT NULL NUMBER
T$AUPP$12 NOT NULL NUMBER
T$AUPP$13 NOT NULL NUMBER
T$FUPP$1 NOT NULL NUMBER
T$FUPP$2 NOT NULL NUMBER
T$FUPP$3 NOT NULL NUMBER
T$FUPP$4 NOT NULL NUMBER
T$FUPP$5 NOT NULL NUMBER
T$FUPP$6 NOT NULL NUMBER
T$FUPP$7 NOT NULL NUMBER
T$FUPP$8 NOT NULL NUMBER
T$FUPP$9 NOT NULL NUMBER
T$FUPP$10 NOT NULL NUMBER
T$FUPP$11 NOT NULL NUMBER
T$FUPP$12 NOT NULL NUMBER
T$FUPP$13 NOT NULL NUMBER
T$REFCNTD NOT NULL NUMBER
T$REFCNTU NOT NULL NUMBER

@ nelsonR

Thanks for your explanation. I used the information and was able to retrieve the requested data; problem solved!

Regards

Dirk