rrankinmba
14th November 2005, 21:12
Good day,

We recently had our test database refreshed from production. In the process we also brought the text tables. Now in test when a user tries to add new text (i.e. Create) instead of a blank text box they are getting the text from something already created.

This has happened in customer master, in exchange conditions, and even when attempting to add a new text in text maintenance.

Is there is there a place where a first number needs to be reset?

Thanks for the help,

Bob

rrankinmba
14th November 2005, 23:05
BaanIVc, Unix HPUX10.20, Oracle7

norwim
15th November 2005, 08:59
Hmm,

don't really like to point that out, ... but you must have done something wrong. :-)
So what basically happens when you use a text in Baan, is that the text number (and the language!) is used a a key to find the text contents in tttxt010XXX (XXX being your Company).
So 2 things might have happend:
a) you changed tttxt010 but left the other tables unchanged (so their text numbers point to wrong texts)
b) vice versa tttxt010 wasn't copied, but the other files were.

A good reason for this might be that you read in the data via bdbpre6.1 in append mode instead of killing the table before populating it with fresh data.

Another reason could be that you are using different languages between test and production system, but I reasoned that this would have been obvious.

hth

Norbert