Anybody ever faced a problem with the address record (tracs100) and the limitation of having 999999 as the maximum cadr? We're at 962000 and growing. The field is a string, but Baan Support does not suggest using alphanumeric cadrs. What are some possible workarounds?

Besides session tracs1200m000, there are some workarounds:

*make your own correction program to change the existing addresscodes in tracs100 and in all related tables. After that tracs000.frno can be set to 1.
* change the domain of cadr

Regards,
Klaas

FYI,

Baan has said they are going to start work on making this field alphanumeric. I don't know wether it will be optional or how they are going to implement it, but we did get word today that it will be changed.