Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
18%
200 - 500 GB
29%
500 - 800 GB
3%
800 - 1200 GB
7%
1200 - 1500 GB
8%
1500 - 2000 GB
12%
> 2000 GB
23%
Total votes: 73

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 6th September 2019, 10:24
RavCOder's Avatar
RavCOder RavCOder is offline
Member
 
Join Date: Jul 2019
Posts: 48
RavCOder is on a distinguished road
Baan: 10.3 - DB: SQL Server - OS: Windows
Insert a field form which takes the value from a script
Baan: Other/Unknown
C/S: None/Unknown

Hi,

I want to insert a display field that show me the sum of order quantity.
I ihave inserted the query into a script and I have inserted the display field into DFE.

My question is how do I link the final result of my query into the display form?

Regards,

-RavCoder-
Attached Images
File Type: png Capture_6.PNG (58.9 KB, 10 views)
Reply With Quote
  #2  
Old 6th September 2019, 20:02
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,800
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox Tools 10.7 - DB: tbase, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
display() function

Maybe you can use:
Code:
display()
Syntax:

function void display  (string field)

Description

Use this function to display a specified field on a form. Usually, the 4GL engine displays fields 
automatically, either when the form is opened or when data in a related input field is changed. 
However, there are situations when you need to use these functions to display fields. 
For example, to display stand-alone fields, to display fields that are not in the input 
field TAB sequence, or to send data to the form during batch processes.

display() Displays a single-occurrence field. You cannot use this to display a field for all occurrences. 
 

Arguments

string field Indicates the field to be displayed. This can be the field number or a string containing the field name. For example:

		display( "pctstqqq.item"  )
		 
 
Context

This function can be used in all script types.

See also

display.all(), display.curr.occ(), display.fld(), display.occ()

Notes
This function always display the current value of the specified fields.

The current field pointer and form status are always saved when a display 
function is called and then restored when the function has terminated.

Non-database fields must be declared as extern in the program script.

The function display.all(), display.occ(), and display.curr.occ() do not affect stand-alone fields. 
To display a value for a stand-alone field use display() or display.fld().
__________________
//Bernd
Reply With Quote
Sponsored Links
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
Non-Editable form field in View part sameer.don Tools Development 4 4th January 2011 06:55
Query on multioccurence form field bigjack Tools Development 8 29th May 2006 13:15
Setting Form Field mostrightfuture Tools Development 5 11th June 2004 17:46
text field on form jmathew Tools Development 6 2nd September 2003 14:40


All times are GMT +2. The time now is 14:09.


©2001-2018 - Baanboard.com - Baanforums.com