Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

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 17th July 2017, 16:19
qiangyao qiangyao is offline
Junior Member
 
Join Date: Apr 2007
Posts: 28
qiangyao is on a distinguished road
Baan: ln61 fp3 - DB: oracle - OS: windows2003 server
How to display SQL query results on the Form
Baan: ERP LN 6.1 FP10 (Infor ERP 10.4)
C/S: None/Unknown

hi
I use SQL select qmptc011.quid,qmptc011.item,qmptc015.* from qmptc011 left join qmptc015 on qmptc011.quid = qmptc015.quid

But Only display qmptc011 results,Can't dislay SQL query results on the Form.
Please help me.
Thanks
Reply With Quote
Sponsored Links
  #2  
Old 17th July 2017, 18:14
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,287
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
Hi,

Can you elaborate what you are trying to do here?

Is this query a part of Baan/LN session? Or is it an Easy SQL Query?

By looking at it's syntax, it looks more of an SQL Query used to run on the Database.
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
  #3  
Old 18th July 2017, 17:39
qiangyao qiangyao is offline
Junior Member
 
Join Date: Apr 2007
Posts: 28
qiangyao is on a distinguished road
Baan: ln61 fp3 - DB: oracle - OS: windows2003 server
Table qmptc011 is Testing Combinations
There are item and it's Standard Test Produce in qmptc011.
as As shown below.
item Standard Test Produce code
A x01

Table qmptc015 Including the details of Standard Test Produce
as As shown below.

Standard Test Produce code ver aspect norm Lower limit Upper limit
x01 1 y01 4 3 5 6
x01 1 y02 4 3 5 6

I want to read item and Standard Test Produce code,then read all details According to the Standard Test Produce code.

as As shown below display on form.

item Standard Test Produce code ver aspect norm Lower limit Upper limit

A x01 1 y01 4 3 5 6
A x01 1 y02 4 3 5 6
Reply With Quote
  #4  
Old 19th July 2017, 12:42
vamsi_gujjula's Avatar
vamsi_gujjula vamsi_gujjula is offline
Senior Member
 
Join Date: Nov 2011
Location: hyderabad ; india
Posts: 240
vamsi_gujjula is on a distinguished road
Baan: ERPLN fp3 and 10.4 - DB: oracle - OS: Aix , Redhat linux 6
Assuming this is for session .

Please check 'secondary tables' concept .
__________________
Regards,
Vamsi
Reply With Quote
  #5  
Old 19th July 2017, 19:52
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,639
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox - DB: tbase, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
You don't answer bushan's question

Hello,
you don't answer bhushan's question.

Is it a sessionscript
or
is it an easy SQL Query ?

Regards
__________________
//Bernd
Reply With Quote
  #6  
Old 21st July 2017, 04:24
qiangyao qiangyao is offline
Junior Member
 
Join Date: Apr 2007
Posts: 28
qiangyao is on a distinguished road
Baan: ln61 fp3 - DB: oracle - OS: windows2003 server
Hi all,
I have provided detailed requirements in the attachment.
Please help me. thanks
Attached Files
File Type: xls sample.xls (28.5 KB, 6 views)
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
Programming Question mr_suleyman Tools Development 37 11th November 2016 08:14
EASY SQL QUERY: Japanese Form Label not displayed completely. fredintaiwan Tools Development 0 4th December 2008 06:59
Selecting recs for display on form JRussell Tools Development 0 25th October 2002 15:36


All times are GMT +2. The time now is 23:33.


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