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
8%
1200 - 1500 GB
8%
1500 - 2000 GB
12%
> 2000 GB
23%
Total votes: 77

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 4th September 2019, 10:05
RavCOder's Avatar
RavCOder RavCOder is offline
Senior Member
 
Join Date: Jul 2019
Posts: 105
RavCOder is on a distinguished road
Baan: 10.3 - DB: SQL Server - OS: Windows
Lightbulb How don't have duplicate value in a display session?
Baan: Other/Unknown
C/S: None/Unknown

Hi,
I created this thread to know how don't have duplicate value in a display session.
I created a session that displays some value (business partner in table tdsls400), but I don't know how "delete" duplicate value.

Code:
declaration:

table ttdsls400 
string old.ofbp 
**********MAIN TABLE SECTION**************
main.table.io:
after.read:
if old.ofbp = tdsls400.ofbp then 
              skip.io("")
else
      old.ofbp = tdsls400.ofbp
endif
*********FUNCTION SECTION**********
functions:
function view_data()
{
 select tdsls400.ofbp , tdsls400.orno
   from tdsls400
  selectdo
  endselect 
}
Attached Images
File Type: png Capture_5.PNG (11.3 KB, 11 views)

Last edited by RavCOder : 18th September 2019 at 11:08.
Reply With Quote
  #2  
Old 18th September 2019, 10:49
oirfeodent's Avatar
oirfeodent oirfeodent is offline
Member
 
Join Date: Jun 2016
Posts: 79
oirfeodent is on a distinguished road
Baan: Baan - DB: DB - OS: OS
Quote:
Originally Posted by RavCOder View Post
Hi,
I created this thread to know how don't have duplicate value in a display session.
I created a session that diplays some value (business partner in table tdsls400), but I don't know how "delete" duplicate value.

Code:
declaration:

table ttdsls400 
string old.ofbp 
**********MAIN TABLE SECTION**************
main.table.io:
after.read:
if old.ofbp = tdsls400.ofbp then 
              skip.io("")
else
      old.ofbp = tdsls400.ofbp
endif
*********FUNCTION SECTION**********
functions:
function view_data()
{
 select tdsls400.ofbp , tdsls400.orno
   from tdsls400
  selectdo
  endselect 
}
Use query extension, with an SQL which will satisfy your filter condition.

Regards,
Reply With Quote
Sponsored Links
  #3  
Old 18th September 2019, 11:25
RavCOder's Avatar
RavCOder RavCOder is offline
Senior Member
 
Join Date: Jul 2019
Posts: 105
RavCOder is on a distinguished road
Baan: 10.3 - DB: SQL Server - OS: Windows
Code query extension

I don't know how to use query extensions, but I think this:

Code:
function long after.read.table(){
query.extend.select("tdsls400.ofbp")
query.extend.from("tdsls400")
query.extend.where ("tdsls400.ofbp =: tdsls400.ofbp")

}
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
Error - cannot read session or object on print report attempt anthony peiris AFS/DDC/OLE: Function servers 2 14th December 2010 14:36
adding additional field in standard display session VishalMistry Tools Development 3 12th July 2010 15:50
Find in a Customized Display Session Hiba_t Tools Development 2 11th March 2008 10:12
Display session with multiple forms, main forms single-occ, last form multi-occ en@frrom Tools Development 21 9th January 2007 21:53
View field of display session keeps resetting value to first record in table!!?? en@frrom Tools Development 2 25th August 2006 16:26


All times are GMT +2. The time now is 07:58.


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