Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
Would you like to see a separate forum on Baanboard for the ION product?
No
14%
Yes
86%
Total votes: 80

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 1st June 2012, 16:48
metropoj metropoj is offline
Senior Member
 
Join Date: Feb 2004
Location: Oshawa
Posts: 194
metropoj is on a distinguished road
Baan: LN FP7 - DB: MSSQL - OS: Win 7
Question Selecting Product Feature "Option" Descriptions & Text
Baan: ERP LN 6.1 FP7
C/S: None/Unknown

Question please.

Product Feature called [Catno]

There are catalog options for this feature such as 10000, 10001, 10002, etc

Each Option also has text assigned to it. So you have options that contain the option number, the small text and the detailed attached 'text' itself ..

We want to concatenate the option number ( 10000 ) with the 'text' attached to that option. How do you do this ? I assume I have to do calls to other tables . I hoped it would be more straight forward ...

I also see within the Configuration Parameters different Constraint Expressions for text like text BOM, Operations text, etc. Anything in there that may help ?

Thanks in advance ...

Last edited by metropoj : 1st June 2012 at 16:50. Reason: update
Reply With Quote
Sponsored Links
  #2  
Old 1st June 2012, 17:43
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Louisville, KY, USA
Posts: 5,944
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Well not sure I got all of the request, but this simple little code writes text from two tables to files, appends one and then writes it back into baan. Now this is code is written for our UNIX systems, but the technique can be used for windows servers.
Code:
function append.text(domain tcmcs.str16 some.field)
{
	string	temp.file1(500), temp.file2(500), cmd(1024)
	string	kw1(17),kw2(17),kw3(17),kw4(17),tgrp(8),eopt(15)
	long	write.return, ret.code

	temp.file1 = creat.tmp.file$(bse.tmp.dir$())
	temp.file1 = strip$(temp.file1)
	write.return = text.read("tdudi010.txtn", "2", kw1, kw2, kw3, kw4, tgrp, eopt, temp.file1, 0)

	temp.file2 = creat.tmp.file$(bse.tmp.dir$())
	temp.file2 = strip$(temp.file2)
	write.return = text.read(some.field, "2", kw1, kw2, kw3, kw4, tgrp, eopt, temp.file2, 0)
	
	cmd = sprintf$("cat %s>>%s", temp.file1 , temp.file2)
	ret.code = shell(cmd, SHELL_NO_OUTPUT)
	
	write.return = text.rewrite(some.field, "2", kw1, kw2, kw3, kw4, tgrp, "", temp.file2)
	commit.transaction()
	ret.code = seq.unlink(temp.file1)
	ret.code = seq.unlink(temp.file2)
}
__________________
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 1st June 2012, 19:17
metropoj metropoj is offline
Senior Member
 
Join Date: Feb 2004
Location: Oshawa
Posts: 194
metropoj is on a distinguished road
Baan: LN FP7 - DB: MSSQL - OS: Win 7
Thx.

I was hoping that there was just some easier link but only seems it is easy to print the Option "Description" from the pcf110 table and then have to call to match option text number.

I like what you have here for the different languages and we may use something like this if required however.

Cheers.
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
Copy text between companies en@frrom Tools Development 5 17th August 2010 04:09
Programming Question mr_suleyman Tools Development 34 24th February 2009 12:07
No read authorization for text group text aihbikers Tools Development 2 31st October 2003 15:26
What setup is needed in for creating Sales Quotation text from Product Configurator jaymukh Distribution, Transportation & Warehousing 1 27th April 2002 10:13


All times are GMT +2. The time now is 04:55.


©2001-2013 - Baanboard.com - Baanforums.com