Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Open World, Portal & Decision Manager

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
55%
Installation Wizard into new VRC
18%
Manual into existing VRC
9%
Manual into new VRC
18%
Total votes: 11

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 21st February 2017, 15:35
RieseUSA's Avatar
RieseUSA RieseUSA is offline
Member
 
Join Date: Mar 2003
Location: Toronto, Canada
Posts: 41
RieseUSA is on a distinguished road
Baan: n/a - DB: n/a - OS: n/a
BDE - Control of Text Language?
Baan: ERP LN 6.1 FP11 (Infor ERP 10.5)

I need to create a BDE that allows to store the text in a language different from the one of the connection to LN.

This question has been asked in a different way before, but no answer has been found:
http://www.baanboard.com/baanboard/s...ad.php?t=66748
http://www.baanboard.com/baanboard/s...ad.php?t=66750

The text field being passed to the BDE has the datatype 'tctxtn', which has a DB Type of 'db.text'. Internally, the BDE calls a function 'convert.xml.to.text()', which converts the content of the XML node to a text number. The text is stored with the language set for the user of the connection. The requirement is that the text needs to be stored in language 'x' instead.

- Using a connection with a different user/language is not a solution, because it could be that the table has several text fields that require different languages.

- I tried using the 'After Execute Hook' to 'transfer' the text via the 'text.copy.language.shared()' function from the current language to 'x'. It works for a 'Create', but I have seen that the Text Keyword fields are getting blanked out, so there is some conflict with the text handling. When trying the same for a 'Change', it does not work. The function 'text.present.in.language.shared()' returns that text exists for the source language, but when using 'text.copy.language.shared()', it does not find any. I am suspecting that this is caused by the tools processing (some of) the text in a separate database transactions, so that the text number is created without locking the text indefinitely.

- A suggestion of one the previous posts was to pass the text as a string and then store that with the correct language. This has the the limitation that text cannot be longer than the maximum length of the domain, so it is not ideal, either.

Does anyone have any experience or suggestions with this?
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
Programming Question mr_suleyman Tools Development 37 11th November 2016 08:14
Changing the Text language on form filter cyrilchacko Tools Development 3 18th January 2011 18:09
printing different languages on one layout olabas Tools Development 8 21st May 2002 14:27


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


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