topic Re: help in delete in Application Development and Automation Discussions

help in delete

Former Member — Wed, 19 Mar 2008 08:24:51 GMT

Hi,

I do this statement and its not working,

what is the way to delete table when subty ne the nuber in brackets?

DELETE t_4000 WHERE subty NOT IN ( 01 , 12 , 11, 16 , 17 , 29).

Regards

Re: help in delete

Former Member — Wed, 19 Mar 2008 08:28:23 GMT

HI,

try like dis.......

DELETE t_4000 WHERE subty NOT IN ('0001','0012','0011','0016','0017','0029').

Re: help in delete

ak_upadhyay — Wed, 19 Mar 2008 08:29:53 GMT

Hi,

Check this....

DELETE t_4000 WHERE subty NOT IN ( '01' , '12' , '11', '16' , '17' , '29').

Reward points if useful....

Regards

Re: help in delete

Former Member — Wed, 19 Mar 2008 08:33:13 GMT

Hi Jose

i try like u write and i get error :

Field "('0001','0012','0011','0016','0017','0029')" is unknown. It is

neither in one of the specified tables nor defined by a "DATA"

statement.

Re: help in delete

Former Member — Wed, 19 Mar 2008 08:39:11 GMT

leave a space after the '(' and before ')'

Re: help in delete

Former Member — Wed, 19 Mar 2008 08:43:00 GMT

not answerd

Re: help in delete

Former Member — Wed, 19 Mar 2008 08:44:50 GMT

try like this



DELETE t_4000 WHERE  subty ne ' 01' and
                                       subty ne  '12'  and
                                       subty ne  '11'  and
                                       subty ne  '16'  and
                                       subty ne  '17'  and
                                       subty ne  '29' ).

Hope it would help you.

Regards,

Venkatram

Re: help in delete

Former Member — Wed, 19 Mar 2008 08:46:29 GMT

Hi,

Seems Where not in ('.....) is allowed only with SELECT statement

code like below...

DELETE t_4000 WHERE  ( subty NE '0001' 
                    or subty NE '0012' 
                    or subty NE '0011' 
                    or subty NE '0016' 
                    or subty NE '0017' 
                    or subty NE '0029' ).

Cheers,

jose.

Edited by: Jose on Mar 19, 2008 9:47 AM