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

User login

Frontpage Sponsor


Google search

For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
Installation Wizard into new VRC
Manual into existing VRC
Manual into new VRC
Total votes: 49

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 14th December 2016, 17:01
BaBernd BaBernd is offline
Senior Member
Join Date: Mar 2015
Posts: 139
BaBernd is on a distinguished road
Baan: Infor 10.2.1 - DB: SQL-Server 2012 - OS: Windows Server 2008
Join a record set and a variable for print record
Baan: Other/Unknown
C/S: None/Unknown

Hello to All,

within a function I'll execute a select on table cprrp041 (is not necessarily important which table). In the selectdo area the function tccom.dll0010.print.record(1) transfers the record set to a report.
But I also like to transfer a calculated variable (here cal.week) within this selectdo area to the report. But it doesn't. I also tried the export()-function within the selectdo, but I haven't also no success.
Does anyone has an idea how I can join the result of the variable with the record set for transfer.

Here an example of my problem:
function long print.production.order.selection()
select cprrp041.*
from cprrp041
where cprrp041.koor = 3
	cal.week = val(sprintf$("%u(%02W)",  |* calculated calendar week
	tccom.dll0010.print.record( 1 )  |* record set transfer
Best Regards
Reply With Quote
Sponsored Links
Old 14th December 2016, 20:59
mark_h's Avatar
mark_h mark_h is offline
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,111
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Did you add the field to the report? I know in 4c4 we use print record in a few programs which are in our version of tccomdll010 which does I think the same thing. I am assuming you use the and point it to the correct report.

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
Old 14th December 2016, 22:03
hklett's Avatar
hklett hklett is offline
Join Date: May 2002
Posts: 54
hklett is on a distinguished road
As Marc mentioned you have to make this field as an input field in your report.
Did you declare this variable as extern?
Reply With Quote
Old 15th December 2016, 11:10
BaBernd BaBernd is offline
Senior Member
Join Date: Mar 2015
Posts: 139
BaBernd is on a distinguished road
Baan: Infor 10.2.1 - DB: SQL-Server 2012 - OS: Windows Server 2008
I also added this field in the "input fields..." for the report, before. But I've got the error
"Process xx - Fatal Error: process xx: mv_symbols error: INCOMPATIBLE TYPES: (cal.week LONG|ARRAY|EXTERN|NO_ALLOC_MEM, cal.week LONG|EXTERN)
Process xx - Fatal Error: Can not continue in rtisfc0401010010 in DLL: ottstprepdll (r.main)[]"
So I've thought to export and import the variable value. But with that methode I've got no values into the report.

when I've created the input field I set the depth = 2. I've mixed it with the Domain property "Digits before Decimal = 2"
Now I've changed the value "depth = 0". The INCOMPATIBLE TYPES-Error doesn't occur. And the values will be correctly transferred to the report.

Thanks a lot for your help. Therefore I've recognized that I'm on the wrong track with my thread "joining record set and variable". Problem was the wrong defined input field.

Best Regards

Last edited by BaBernd : 15th December 2016 at 11:13. Reason: Editing text
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
text.write does not return new text number ahulikavi Tools Development 10 4th September 2017 11:03
Programming Question mr_suleyman Tools Development 37 11th November 2016 08:14
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
Detected database server termination (help! aide! ayuda! hilfe! ayuto! hellup! •‚¯!)! Francesco Operating Systems & Databases 15 20th July 2002 11:37

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

©2001-2018 - -