topic Re: Query - If doesn't work with is initial in Application Development and Automation Discussions

Query - If doesn't work with is initial

antonio_bruno — Wed, 29 Apr 2015 07:11:30 GMT

Hi,

I've problem with an if in a query.

In particular when the select field SS (special stock declared as selection criteria) hasn't values, the 2nd if doesn't work (if... SS is initial).

I've debbugged the query, the SS is empty but the program jump the 2nd if and goes directly to endif,

Where is the mistake?

Thanks and regards.

Antonio

former_member538259 — Wed, 29 Apr 2015 07:34:04 GMT

need the work area o the values in the internal table with header?

Former Member — Wed, 29 Apr 2015 07:39:14 GMT

HI,

try to write IF SS[] is initial and check.

Former Member — Wed, 29 Apr 2015 07:48:39 GMT

Hi,

To make sure that it is the 'SS is initial' condition that is getting missed, split your if into two (for testing only).

IF ( DD NE ' ' ) AND ( MAG NE ' ' ) AND (TM NE ' ' ).

IF (SS[] IS INITIAL).

....

ENDIF.

Thanks,

Leena

antonio_bruno — Wed, 29 Apr 2015 10:04:38 GMT

Hi,

I've solved with elseif instead if.

Now the elseif works properly also without [].

Thanks for the help.