Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 14th December 2016, 18:01
BaBernd BaBernd is offline
Senior Member
 
Join Date: Mar 2015
Posts: 135
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:
Code:
function long print.production.order.selection()
{
select cprrp041.*
from cprrp041
where cprrp041.koor = 3
selectdo
	cal.week = val(sprintf$("%u(%02W)",cprrp041.date)  |* calculated calendar week
	tccom.dll0010.print.record( 1 )  |* record set transfer
endselect
}
Best Regards
Bernd
Reply With Quote
  #2  
Old 14th December 2016, 21:59
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,929
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 open.report and point it to the correct report.
__________________
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 14th December 2016, 23:03
hklett's Avatar
hklett hklett is offline
Member
 
Join Date: May 2002
Posts: 45
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
  #4  
Old 15th December 2016, 12:10
BaBernd BaBernd is offline
Senior Member
 
Join Date: Mar 2015
Posts: 135
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
Code:
"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)[handle.report.pool]"
So I've thought to export and import the variable value. But with that methode I've got no values into the report.

Solution:
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
Bernd

Last edited by BaBernd : 15th December 2016 at 12:13. Reason: Editing text
Reply With Quote
Sponsored Links
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
text.write does not return new text number ahulikavi Tools Development 10 4th September 2017 12:03
Programming Question mr_suleyman Tools Development 37 11th November 2016 09:14
Which Set Commands Do You Use? Why? mr_suleyman Tools Development 14 16th January 2014 22:44
BW client parameters lsatenstein Tools Administration & Installation 2 31st January 2012 22:29
Detected database server termination (help! aide! ayuda! hilfe! ayuto! hellup! •‚¯!)! Francesco Operating Systems & Databases 15 20th July 2002 12:37


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


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