topic Re: Issue with SELECT statement in Application Development and Automation Discussions

Issue with SELECT statement

Former Member — Thu, 02 Oct 2008 20:06:35 GMT

Hi All,

I have an issue with SELECT statement. In select statement though i am excluding some values which are in range table, those values are also getting selected.

I am using select statement like this.

select fielda fieldb fieldc... fieldn from table zzallt into corresponding fields of t_zzallt where saknr in s_saknr

and rcomp not in r_rcomp.

where s_saknr is select options and r_rcomp is range table. I should not select saknr values which are in r_rcomp, but are being selected. Please tell me where I am wrong.

Thanks

Suresh

Re: Issue with SELECT statement

Former Member — Thu, 02 Oct 2008 20:13:28 GMT

Hi,

Dont do like this

select fielda fieldb fieldc... fieldn from table zzallt into corresponding fields of t_zzallt where saknr in s_saknr

and rcomp not in r_rcomp

when populating the r_rcomp, assign the sign as 'NE' ( Not equal to )

then write your query as

select fielda fieldb fieldc... fieldn from table zzallt into corresponding fields of t_zzallt where saknr in s_saknr

and rcomp in r_rcomp

regards,

Advait

Re: Issue with SELECT statement

Former Member — Thu, 02 Oct 2008 20:21:56 GMT


> when populating the r_rcomp, assign the sign as 'NE'    ( Not equal to )

I don't think that will work. The option should be 'EQ' and the sign 'E' (exclude).

Rob

Re: Issue with SELECT statement

Former Member — Thu, 02 Oct 2008 20:25:02 GMT

Hello Rob,

Sorry about that and thanks for correcting me, I always get confused between the sign and the option

And I did the goof up this time too

regards,

Advait

Re: Issue with SELECT statement

Former Member — Thu, 02 Oct 2008 20:26:50 GMT

The important part is that NE won't work. Everything will be selected.

Rob

Re: Issue with SELECT statement

Former Member — Thu, 02 Oct 2008 20:33:53 GMT

Aha ! you mean r_comp-sign = 'I' and Option = 'NE' wont work ?

regards,

Advait

Re: Issue with SELECT statement

Former Member — Thu, 02 Oct 2008 20:39:00 GMT

It'll work, but select everything. Remember that rows in select-options are strung together by ORs. So if you say SELECT something where field NE 1 OR field NE 2, all records will fulfil that.

Rob

Re: Issue with SELECT statement

Former Member — Thu, 02 Oct 2008 21:22:28 GMT

Thanks Rob n Advait, thanks for your suggestions..

Suresh