topic Re: Problem in clear modify statement(urgent) in Application Development and Automation Discussions

Problem in clear modify statement(urgent)

Former Member — Wed, 01 Nov 2006 06:06:36 GMT

hi experts,

I have one z table.i fetch the data from ztable and i display it in the screen.In screen i change that data and i want to save that data in that table.How to do that.

my ztable structure is

year(key) customer(key) month(key) quantity1 quantity2 quantity3.

my select statement is.

select quantity1 from ztable into wa where customer = xxxx and year = xxxx and month =xx.

i put the fetched data in screen. in screen i did some calculation.After the calculation the quantity1 value changes.finally i want to save the changed data in the same ztable.

my query is .

modify ztable from wa where year = xxxx and customer = xxxx and month = xx.

the above queury is not working.

Please give me the solution for this

thank you,

regards,

Ashok.

Re: Problem in clear modify statement(urgent)

Former Member — Wed, 01 Nov 2006 06:14:14 GMT

Add

commit work.

after your MODIFY statement.

Regards,

Amey

Re: Problem in clear modify statement(urgent)

Former Member — Wed, 01 Nov 2006 06:24:16 GMT

Instead of using modify for database tables use update

update ztable

set quantity1 = wa-quantity1

where where year = xxxx and customer = xxxx and month = xx.

Re: Problem in clear modify statement(urgent)

anversha_s — Wed, 01 Nov 2006 06:43:58 GMT

hi,

try this.

DATA ztable_wa TYPE ztable.

select year customer month quantity1

from ztable into ztable_wa

where customer = xxxx and year = xxxx and month =xx.

ztable_wa-quantity1 = new_quantity.

MODIFY ztable FROM ztable_wa.

rgds

anver

if hlped pls mark points

Re: Problem in clear modify statement(urgent)

Former Member — Wed, 01 Nov 2006 07:38:03 GMT

hi,

thank you very much.Above both the answers solved my problem.

thanks ravi and anversha.

regards,

Ashok

Re: Problem in clear modify statement(urgent)

Former Member — Wed, 01 Nov 2006 08:16:00 GMT

hi ashok,

Assign the screen field value to the z.table field as

z.table-field(s) = screen field(s)

then u use modify statement ,it will work