topic Re: modify statement for data base table.. in Application Development and Automation Discussions

modify statement for data base table..

former_member217546 — Fri, 05 Mar 2010 06:13:58 GMT

hi friends i am using modify statement to update / insert new entries in the db table with internal table.

when i try to modify the data it will be automatically sorted out by the primary keys.

i don't want the data would be sorted out instead it should be updated as it is.

Re: modify statement for data base table..

Former Member — Fri, 05 Mar 2010 06:15:55 GMT

Well what difference does it make whether the DB table is sorted or not with the values you modify?

Re: modify statement for data base table..

Former Member — Fri, 05 Mar 2010 06:31:11 GMT

Hi...

use this logic..

select empno status marks from DB into table int2

where empno = DB-empno.

loop at int2 into wa2.

read table int1 into wa1 where empno = wa2-empno.

wa1-status = status.

wa1-marks = marks.

modify int1 from wa1 transporting status marks.

endloop.

Regards,

Lokeswari.

Re: modify statement for data base table..

Former Member — Fri, 05 Mar 2010 06:36:44 GMT

Hi Sudheer ,

is the data in your internal table getting sorted automatically or is it the data in the database table.

If its the data in the internal than declare tha internal table as a standard table.If the internal table is declared as type sorted table then by default the data would be sorted.

Hope this helps you.

reagards ,

Navya.

Re: modify statement for data base table..

Former Member — Fri, 05 Mar 2010 06:36:51 GMT

And why the same is required?

Check if you can achive your requirement by using logic in code.

Re: modify statement for data base table..

matt — Fri, 05 Mar 2010 06:52:42 GMT

There is no concept of "order" on a relational database table. Therefore your question is meaningless.

matt

Re: modify statement for data base table..

former_member217546 — Sat, 06 Mar 2010 08:17:52 GMT

thank u ..yes i under stood ..sry for this question.