topic Move query in Application Development and Automation Discussions

Move query

Former Member — Mon, 06 Nov 2006 12:53:28 GMT

can anyone write the below code syntax free i want to move sf_po-header-version_no - 1 to v_version

if sf_po-header-version_no = '0' or ' '.

move '0' to v_version.

else.

move (sf_po-header-version_no - 1) to v_version.

endif.

Re: Move query

Former Member — Mon, 06 Nov 2006 12:55:47 GMT

check this.

if sf_po-header-version_no = '0' or sf_po-header-version_no = ''.
move '0' to v_version.
else.
sf_po-header-version_no = sf_po-header-version_no - 1.
move sf_po-header-version_no  to v_version.
endif.

regards

Prabhu

Re: Move query

Former Member — Mon, 06 Nov 2006 12:57:01 GMT

Hello Joseph,

Remove the Parathathes in the move statement.

If useful reward.

Vasanth

Re: Move query

anversha_s — Mon, 06 Nov 2006 12:58:21 GMT

Hi,

if sf_po-header-version_no = '0' or sf_po-header-version_no = ''.

move '0' to v_version.

else.

sf_po-header-version_no = sf_po-header-version_no - 1.

move sf_po-header-version_no to v_version.

rgds

anevr

endif.

Re: Move query

Former Member — Mon, 06 Nov 2006 12:58:32 GMT

if ( ( sf_po-header-version_no = '0' ) or ( sf_po-header-version_no = ' ' ) ).

move '0' to v_version.

else.

v_version = sf_po-header-version_no - 1.

endif.

reward points if helpful.

Regs

Manas Ranjan Panda

Re: Move query

Former Member — Mon, 06 Nov 2006 13:30:13 GMT

hi,

data: a like sf_po-header-version_no .

a = sf_po-header-version_no - 1. <<better declare a variable and assign the value,then use it below.

case sf_po-header-version_no.

when '0'.

move '0' to v_version (or)

v_version = '0'.

when ' '.

v_version = '0'.

when others.

move a to v_version.

endcase.

please assign points if it helps you

regards,

sowjanya

Message was edited by: sowjanya s