metropoj
1st June 2012, 17:48
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 ...

mark_h
1st June 2012, 18:43
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.

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)
}

metropoj
1st June 2012, 20:17
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.