Can any one help me out ,
We are using Baan 4C4 with SQL SERVER 2000 and have HR module also .

:confused:

Problem : We have employee codes as follows
Permanent Employees : 1 to 1000
Trainees : 1048 to 2000
Casuals : 5000

Now the problem is , our permanent employee code has reached 995 and wont be able accept 1001 as emp code for permanent now we need to change the series but than it might effect many tables can u please give some suggestions .

Email : niraj.kakodkar@gmail.com

Hi there,

from memory (can't access a system atm) the employee number is of type long, so you should be able to use number 10000-..... .
If you indeed wish to shift all numbers used so far, you will have to examine the data dictionary to identify the tables involved. This is the tricky part, unfortunatly sometimes fields are used with wrong domains, but with some careful work one might be able to identify all tables which have to be converted/changed. The program to actually shift the numbers should be trivial, I would use bdbpre/awk/bdbpost.

hth

Norbert