topic Re: Table Maintainance Generator Updation problem in Application Development and Automation Discussions

Table Maintainance Generator Updation problem

Former Member — Thu, 18 Sep 2008 04:05:47 GMT

Hello,

I am having the problem related to table maintainence generator updation.

I am fetching the data in table maintainance generator from Standard table.

Now the problem is that, if I fetch some records ; some records are updated properly but some records are not.

Please suggest the solution.

Thanks.

Swati.

Re: Table Maintainance Generator Updation problem

Former Member — Thu, 18 Sep 2008 04:12:57 GMT

Check that is there any foreign key relation maintained in that standard table

Re: Table Maintainance Generator Updation problem

Former Member — Thu, 18 Sep 2008 04:30:51 GMT

Hello Swati,

Check your table for key fields, it is possible that you are trying to change key field value. As you cannot change key field value a new entry is created is created every time.

Hope this solves your problem.

Regards,

Brajvir

Re: Table Maintainance Generator Updation problem

Former Member — Thu, 18 Sep 2008 04:33:45 GMT

If the Key fields already exsist in table than new entry would not be created again with same key field.

Check table carefully if the values with the key field may be already exsist.

Edited by: Ámit Güjärgoüd on Sep 18, 2008 6:33 AM

Re: Table Maintainance Generator Updation problem

Former Member — Thu, 18 Sep 2008 04:50:58 GMT

Hello All.

Thanks for your reply.

The field which is not updating is not the key field.

Thanks.

Swati

Re: Table Maintainance Generator Updation problem

Former Member — Thu, 18 Sep 2008 04:55:07 GMT


> Hello All.
> Thanks for your reply.
> The field which is not updating is not the key field.
> 
> Thanks.
> Swati

It does't matter.

But the fields is not updating you need to check its key in table whether it is exsist?

I'm yes it is there.

One more thing i would like to confirm are you using Update or modify?

Re: Table Maintainance Generator Updation problem

Former Member — Thu, 18 Sep 2008 05:58:16 GMT

Thanks to all for replying.

Problem has been resolved.