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

User login

Frontpage Sponsor


How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 73

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 11th September 2019, 12:30
RavCOder's Avatar
RavCOder RavCOder is online now
Join Date: Jul 2019
Posts: 48
RavCOder is on a distinguished road
Baan: 10.3 - DB: SQL Server - OS: Windows
Create a DLL to show sum
Baan: Other/Unknown
C/S: None/Unknown

I have to create a DLL for print report that show me a sum ( I have created function yet but I don't know where I put this function).

this is my function:
function sum_period (){

sum_order = 0 
select tdsls900.bpid, tdsls900.qoor, tdsls900.odat
from tdsls900
select tdsls900.odat, tdsls900.qoor
from tdsls900
group by tdsls900.odat, tdsls900.qoor
sum_order = sum_order + tdsls900.qoor
I asked what are the steps to do to create a print report and a dll and link them together.

Last edited by RavCOder : 11th September 2019 at 12:34. Reason: Explain better my problem
Reply With Quote
Old 11th September 2019, 14:14
mark_h's Avatar
mark_h mark_h is offline
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,330
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
In 4c4 I would go into maintain libraries ttadv2131m00. Then depending on what I was doing I might or might not pass variables. Below is a sample of - you do not necessarily have to return a field like msg. You could do a function with like function extern domain
long sum_period(). Or what ever you need in that regards.
|* tdapidllinvt  0  VRC B40C c3 dev 
|* API Code for Inventory Transactions
|* hollandv
|* 06-28-00 [07:19]
|* Script Type: Library
|* 20130517	Mark holland	05-17-2013
|* Add code to export more fields for VSS.
|* 20061012 	Mark holland	10-12-2006
|* Add code to export order number and sequence number.  Also remove reason
|* code from the routine.
	table	ttiitm001		| Items
#pragma	used	dll	ottstpapihand	| Baan API Handler

| 20061012 add two export fields
	extern	domain	tcpono		exp.sern
	extern	domain	tcorno		exp.orno
	extern	domain	tcpono		exp.sera
	extern	domain	tcsern		exp.serb	| 20130517.end
			string		whro(10)
			string		sern(10)
			string		some.sera(10)
			string		some.serb(10)	| 20130517.end
|* API Code for doing a bin to bin transfer.
function extern bin_to_bin(
			domain  tcitem		xfer.item,
			domain	tccwar		xfer.frwh,
			domain	tcqiv1		xfer.qty,
			domain	tccwar		xfer.towh,
			domain	tdilc.loca	xfer.floc,
			domain	tdilc.loca	xfer.tloc,
			domain	tdltc.clot 	xfer.lots,
			domain	tcdate,
			ref     string          msg())
	long 	rc
	domain	tcwtst	order.status
	string	serial.number(6), hold.msg(120), order.stat(10)
	msg = hold.msg

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
Sponsored Links
Old 11th September 2019, 16:19
bdittmar's Avatar
bdittmar bdittmar is offline
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
create a DLL


in ttadv2530m000 create a library

e.g. xy xyz dll123 and code your DLL-Logic there

Attached Images
File Type: jpg ttadv2530m000 _ Program Scripts _ Libraries - 000.jpg (54.0 KB, 5 views)
Reply With Quote

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
New Developer Erp LN RavCOder General Discussion & Chat 3 24th July 2019 18:09
Unable to create User Exit DLL VishalMistry Tools Development 3 11th June 2018 08:55
Which Set Commands Do You Use? Why? mr_suleyman Tools Development 14 16th January 2014 21:44
BW client parameters lsatenstein Tools Administration & Installation 2 31st January 2012 21:29
Help regarding tools session rahul.kolhe22 Tools Development 4 22nd January 2010 13:31

All times are GMT +2. The time now is 15:17.

©2001-2018 - -