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
22%
Total votes: 45

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 21st June 2018, 08:51
sakthi kj sakthi kj is offline
Junior Member
 
Join Date: May 2018
Posts: 5
sakthi kj is on a distinguished road
Baan: 9.2 - DB: sql - OS: windows10
File concept
Baan: Other/Unknown
C/S: None/Unknown

I am fresher....

How to the report will be saved in the file
pls...give me the example script
Reply With Quote
Sponsored Links
  #2  
Old 21st June 2018, 13:34
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,070
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Well it might depend on what you are really trying to do. In the below case spool.device could be a printer or a file (depending on the users settings). So it opens the report and brp.open - not prompting for a device, then uses brp.ready to send information to the report, then closes with brp.close. I did not include all the code. Here is another thread like this http://www.baanboard.com/baanboard/s...ght=spool.open

Code:
	rprt.id1 = brp.open("rtdapi042011000", spool.device, 1)
	if rprt.id1<=0 then
		brp.close(rprt.id1)
		rc = appl.delete(lockset)
		return
	endif

	select	tdapi401.*
	from	tdapi401
	where	tdapi401._index1 = {:hold.runn}
	and	tdapi401.orno = :hold.orno
	and	tdapi401.opno = :hold.opno	| 20080811 Add opno to the select
	and	tdapi401.cwar = :hold.cwar
	selectdo
		| Delete outbound for 0 qty
		if tdapi401.qsts = 0 then
			delete_outbound(tdapi401.runn,
				tdapi401.orno,
				tdapi401.pono,
				tdapi401.pono,
				errmsg)
			if not isspace(errmsg) then
				releasedqty = 0
				rptmsg = "Unable to delete 0 qty outbound."
				brp.ready( rprt.id1 )
                       endif

.... do other stuff.....

	brp.close(rprt.id1)
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #3  
Old 22nd June 2018, 06:22
sakthi kj sakthi kj is offline
Junior Member
 
Join Date: May 2018
Posts: 5
sakthi kj is on a distinguished road
Baan: 9.2 - DB: sql - OS: windows10
what is the purpose of appl.delete
Reply With Quote
  #4  
Old 22nd June 2018, 09:12
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,708
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
appl.delete

Quote:
Originally Posted by sakthi kj View Post
what is the purpose of appl.delete
Have a look at.
http://www.baanboard.com/programmers...pl_appl_delete

Regards
__________________
//Bernd
Reply With Quote
  #5  
Old 22nd June 2018, 13:15
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,070
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
I use application locks in the session that the code snippet is from. That is from one of my function servers for outbound(not sure which one) but it keeps 2 users from trying to do the same order.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
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
Undocumented Functions & Variables george7a Tools Development 81 30th September 2015 11:35
Return value -2 on seq.open mmtmalone Tools Development 2 8th January 2014 22:03
Problem with bdpost via Session ttaad4227m000 (Create Table from Sequential Dump) BOBBYLYON Tools Administration & Installation 2 16th October 2009 21:56
bshell received SIGTERM manojsharma Tools Development 11 5th June 2008 09:22


All times are GMT +2. The time now is 01:31.


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