Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Operating Systems & Databases

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 8th September 2009, 15:25
Drikus70 Drikus70 is offline
Junior Member
 
Join Date: May 2009
Posts: 3
Drikus70 is on a distinguished road
Baan: 4 - DB: oracle - OS: windows
Retrieve data from tdinv750
Baan: Baan IVc4
DB: Oracle 10.1.0.x
OS: Other/Unknown
C/S: None/Unknown

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
Reply With Quote
  #2  
Old 8th September 2009, 17:23
nelsonR nelsonR is offline
Member
 
Join Date: Sep 2001
Posts: 92
nelsonR is on a distinguished road
Baan: ERP LN FP6 - DB: SQL Server - OS: Windows Server 2008 64 Bit
Table Structure in Oracle

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
Reply With Quote
Sponsored Links
  #3  
Old 9th September 2009, 09:23
Drikus70 Drikus70 is offline
Junior Member
 
Join Date: May 2009
Posts: 3
Drikus70 is on a distinguished road
Baan: 4 - DB: oracle - OS: windows
@ nelsonR

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

Regards

Dirk
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Retrieve data from table tdinv750 Drikus70 Blogs and Web links 1 9th September 2009 10:54
Application data dictionary vs. run-time data dictionary NPRao Tools Development 5 7th July 2009 08:16
SLM Fail to retrieve customer data thangtq739 Tools Administration & Installation 2 30th December 2008 10:45
ERPJewels Hitesh Shah Third Party Products 10 6th November 2006 05:38
How do I retrieve BW connection data ? walter01 Operating Systems & Databases 3 4th June 2004 09:54


All times are GMT +2. The time now is 00:15.


©2001-2017 - Baanboard.com - Baanforums.com