View Single Post
  #1  
Old 4th September 2019, 10:05
RavCOder's Avatar
RavCOder RavCOder is offline
Senior Member
 
Join Date: Jul 2019
Posts: 106
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