topic Re: modify in Application Development and Automation Discussions

modify

Former Member — Tue, 08 Jul 2008 13:30:59 GMT

hi guyz,

im moving data from databse table into custome table..used modify statement but onli 39 entries are inserting when i have 3965 entries but in my internal table i can see all the entries ...plz advise..

regards

Re: modify

Former Member — Tue, 08 Jul 2008 13:32:41 GMT

Check if your custom table and databse table have the same

primary key fields ...

Re: modify

Former Member — Tue, 08 Jul 2008 13:35:15 GMT

hi,

Use append and check.

Re: modify

Former Member — Tue, 08 Jul 2008 13:35:49 GMT

hi,

try giving a commit work after each modify.

I know this wud reduce performance, but it will not accumulate in the buffer. It will just update the databse and clear the buffer immdtly.

Regards,

Subramanian

Re: modify

Former Member — Tue, 08 Jul 2008 13:35:52 GMT

Hi,

Just check the primary key and

where condition in your MODIFY statement.

The records which are satisfying the conditions those are

inserted into custom table.

Check the condition .

Regards,

Rajitha.

Re: modify

Former Member — Tue, 08 Jul 2008 13:42:12 GMT

solved myself thanks