dnnslbrwn
20th April 2004, 17:09
Thought I would add this although I have already found the answer - but the answer leads to another question:

I created a table with about 10 fields including one text field. The index had to be alphanumeric and because I wasn't thinking too clearly on Friday, I used tcseak as the domain.

Everything was fine except that when I edited text, the BW error message box would pop up with the error above - both when I needed to create a new text as well as when editing an existing text.

It took a while and lots of trial and error in copying the table and slowly cutting out fields and CRDD'ing many times to get the table down to the single index field and the text fields and the error was still happening. I then changed the domain of the index field to tcitem - and the error WENT AWAY!!!

I took a look at the domains and the only difference is that tcitem is left aligned while tcseak is not aligned.

Can anyone shed any light on why this happens? I took a look on the BAAN web site and there are many issues with similar texts and all of the solutions were just "that was fixed with this patch"

Cheers,

-Dennis

GO LEAFS GO!!!!!!

lbencic
20th April 2004, 17:31
I think the difference that is causing this is the fact that tcseak is a 'Multi Byte String' data type. There are all sorts of special rules for multi byte:

Multibyte Overview (http://www.baanboard.com/programmers_manual_baanerp_help_functions_multibyte_strings_overview_and_synopsis)