topic Re: Report in Application Development and Automation Discussions

Report

Former Member — Thu, 01 Nov 2007 07:24:38 GMT

Hi All,

In my program, there is a field Lot Numbers 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 "An entry already exists with the same key"...

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

Thanks,

Anil Kumar

Re: Report

kesavadas_thekkillath — Thu, 01 Nov 2007 07:27:08 GMT

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

Re: Report

Former Member — Thu, 01 Nov 2007 07:27:09 GMT

Hi Anil,

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

Regards,

Atish

Re: Report

Former Member — Thu, 01 Nov 2007 07:29:47 GMT

Hi Anil Kumar ,

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

Regards,

Murugan Arumugam

Re: Report

kesavadas_thekkillath — Thu, 01 Nov 2007 07:31:04 GMT

or just try this,

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

and then try the same

Re: Report

Former Member — Thu, 01 Nov 2007 07:31:55 GMT

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

Re: Report

Former Member — Thu, 01 Nov 2007 08:18:29 GMT

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

Re: Report

Former Member — Thu, 01 Nov 2007 08:19:16 GMT

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

Re: Report

Former Member — Thu, 01 Nov 2007 08:19:41 GMT

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

Re: Report

Former Member — Thu, 01 Nov 2007 08:20:09 GMT

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

Re: Report

kesavadas_thekkillath — Thu, 01 Nov 2007 08:32:56 GMT

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

Re: Report

kesavadas_thekkillath — Thu, 01 Nov 2007 08:35:04 GMT

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.....

Re: Report

kesavadas_thekkillath — Thu, 01 Nov 2007 08:38:08 GMT

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

Re: Report

Former Member — Thu, 01 Nov 2007 09:11:02 GMT

Hi,

Thank U Dear....

Anil Kumar