Report

[Former Member]

Hi All,

In my program, there is a field <b>Lot Numbers</b> having lenght 3 digits....so records come only till 999.....

now i want that lenght converted to 4 digits, because i already used till 999 and want to use 1000 and so on....

I go to in my ztable and change its field length, it changed successfully....but when i craeting new entries in 4 digits like 1000, 1001 and so on, not taking and giving error message that <b>"An entry already exists with the same key"...</b>

Plz tell me as soon as possible.....

Thanks,

<b>Anil Kumar</b>

[kesavadas_thekkillath]

IF ur directly updating your new values into ztable..then it may be of duplicate entries

check if the values of primary key are same with the old values...

Hope this was u r question....:-)

reqard if usefull

[Former Member]

Hi,

I do all this, there is no primary key....

first change the field length and save, active it....

after that i go to se14 and there click on active and adjust database....

but problem is still there.....

Anil Kumar

[Former Member]

Hi Anil,

Have you recreated table maintainace generator? also adjust database using SE14.

Regards,

Atish

[Former Member]

Hi,

I do all this, first change the field length and save, active it....

after that i go to se14 and there click on active and adjust database....

but problem is still there.....

Anil Kumar

[Former Member]

Hi Anil Kumar ,

Please ensure that you have activated the table or not...>

Regards,

Murugan Arumugam

[Former Member]

Hi,

I do all this, first change the field length and save, active it....

after that i go to se14 and there click on active and adjust database....

but problem is still there.....

Anil Kumar

[kesavadas_thekkillath]

or just try this,

in se11 goto utilities menu - >database utility->Adjust and activate database button.

and then try the same

[Former Member]

Hi,

I do all this, first change the field length and save, active it....

after that i go to se14 and there click on active and adjust database....

but problem is still there.....

Anil Kumar

[Former Member]

Hi Anil,

It is for only ur table structure has been changed. Either u have to delete all previous entry od 3 digit nos & reentry all ur required LOT NUMBERs or adjust the table thru SE14.

Reward pts if usefull

Srimanta

[kesavadas_thekkillath]

just double click on the message and see its description....

[kesavadas_thekkillath]

just try this,

just delete that whole field frm table create an field with size 4 with same name in the same position.

adjust and activate database.....

[Former Member]

Hi,

Thank U Dear....

Anil Kumar

[kesavadas_thekkillath]

if didnt work delete all the contents from table,and then try entering values