User login
|
|
|
Frontpage Sponsor
|
|
|
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
|

|
|
|
 |

1st June 2012, 16:48
|
|
Senior Member
|
|
Join Date: Feb 2004
Location: Oshawa
Posts: 194
|
|
|
Baan: LN FP7 -
DB: MSSQL -
OS: Win 7
|
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
|

1st June 2012, 17:43
|
 |
Guru
|
|
Join Date: Sep 2001
Location: Louisville, KY, USA
Posts: 5,944
|
|
|
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.
|

1st June 2012, 19:17
|
|
Senior Member
|
|
Join Date: Feb 2004
Location: Oshawa
Posts: 194
|
|
|
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.
|
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
|
| Thread Tools |
|
|
| Display Modes |
Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|