topic Re: simple Query in Application Development and Automation Discussions

simple Query

Former Member — Wed, 12 Sep 2007 10:07:53 GMT

Hi all

I had a requirement to subtract two Number/Units

Example v_test type anzhl ,

v_test1 type anzhl .

v_test2 type anzhl .

i want to subtract v_test from v_test1 is there any function module is there or we can directly subtract it

like v_test2 = v_test-v_test1 .

will this work

Former Member — Wed, 12 Sep 2007 10:08:59 GMT

hi,

u can directly subtract them

thanks

Former Member — Wed, 12 Sep 2007 10:14:59 GMT

As anzhl is of type DEC.....u can directly subtract two fields.....

Regards

Vasu

Former Member — Wed, 12 Sep 2007 10:17:10 GMT

Hi Hitesh,

Ur code will work if the type is numeric-type.

Otherwise u can use subtract statement.

Regards,

LIJO

former_member196517 — Wed, 12 Sep 2007 10:18:33 GMT

hi Hitesh ,

just put space there while subtracting after v_test in second line..

Data:

v_test type anzhl ,

v_test1 type anzhl ,

v_test2 type anzhl .

v_test = '2.20' .

v_test1 = '1.20' .

v_test2 = v_test - v_test1 .

write v_test2 .

former_member196517 — Wed, 12 Sep 2007 10:19:08 GMT

i mean second last line

Former Member — Wed, 12 Sep 2007 10:19:11 GMT

Hi,

this v_test2 = v_test - v_test1 .

will works.