Baanboard.com

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

User login

Frontpage Sponsor

Main

Google search


Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
36%
Installation Wizard into new VRC
36%
Manual into existing VRC
7%
Manual into new VRC
20%
Total votes: 44

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 13th June 2018, 16:55
bumbaermail bumbaermail is offline
Member
 
Join Date: Aug 2008
Posts: 91
bumbaermail is on a distinguished road
Baan: BaaN IV, V, ERPLN6 - DB: Oracle, Sql Server, Informix - OS: Windows, UNIX
Import Records from Overview Session for multiple select
Baan: ERP LN 6.1 FP11 (Infor ERP 10.5)
C/S: None/Unknown

Hello,

How can I import records from overview session where the more than one records (multiple mark) are selected.

Please check the attached image for better understanding of scenario.

Thanks
Attached Images
File Type: jpg 2018-06-13_16-54-09.jpg (166.3 KB, 12 views)
Reply With Quote
Sponsored Links
  #2  
Old 14th June 2018, 09:51
sachinbaan's Avatar
sachinbaan sachinbaan is offline
Senior Member
 
Join Date: Oct 2013
Posts: 171
sachinbaan is on a distinguished road
Baan: ERP LN - DB: MS SQL - OS: Microsoft Server
Hi,

If you are going to use the form command after selecting record then make use of do.selection() and you can store value of each record in a single string seperated by comma or pipe and export it.

For example
Code:
function extern export.currency()
{
	o.currency = ""

	do.selection(true, set.values)

	export("o.currency", o.currency)

	start.session(MODELESS, "tcflx0501m001", prog.name$, "tcmcs002.ccur")
}

function set.values()
{
	if isspace(o.currency) then
		o.currency = tcmcs002.ccur
	else
		o.currency = o.currency & "," & tcmcs002.ccur
	endif
}
******************************************************************

Import session

Code:
before.program:

	import("o.currency", o.currency)

	new.currency = ""
	new.currency = chr$(034)

	for i = 1 to len(o.currency) step 1
		single.char = o.currency(i)

		if single.char = "," then
			new.currency = new.currency & chr$(034) &  chr$(044) & chr$(034)
		else
			new.currency = new.currency & single.char
		endif
	endfor

	new.currency = new.currency & chr$(034)

	query.extend.where("tcmcs002.ccur IN (" & new.currency & ")")
034 is ascii value of "
044 is ascii value of ,
__________________
Regards,
Sachin

TO DREAM THE PERSON U WOULD LIKE 2 B, IS 2 WASTE THE PERSON U R.

Last edited by sachinbaan : 14th June 2018 at 10:36.
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
Zoom Menu Return Multi Value layswan Tools Development 3 24th July 2012 09:42
Select distinct records thru query extension?? arajasek Tools Development 5 25th August 2010 07:24
synchronizing different occurrences on parent session from child Ruskin Tools Development 8 18th March 2008 17:56
writing records from one session into a different table outra9e Tools Development 7 12th March 2003 19:43
stpapi (called session - empty select) Smiffy AFS/DDC/OLE: Function servers 8 16th November 2001 01:02


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


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