topic Re: Question about writing code in Application Development and Automation Discussions

Question about writing code

Former Member — Mon, 09 Jun 2008 17:18:41 GMT

Hi Everyone,

I need some help in writing some code.

delete DATA_PACKAGE where version ne '010' and

( version LT '040' or version GT '050' ).

delete DATA_PACKAGE where fiscyear < '2007'.

Is there a way where I can restrcit version 040-050 to only 2008 and get version 010 from 2007.

Thanks

Re: Question about writing code

Former Member — Mon, 09 Jun 2008 17:22:07 GMT

Something like this should work


delete DATA_PACKAGE 
  where ( fiscyear = 2007 AND version ne '010' )
     or ( fiscyear = 2008 and ( version LT '040' 
                            and version GT '050' ).

whoops.. corrected

Edited by: Paul Chapman on Jun 9, 2008 1:23 PM

Re: Question about writing code

Former Member — Mon, 09 Jun 2008 20:35:37 GMT

Hello,


  DELETE data_package WHERE ( version = '010' AND fiscyear = '2007' ) OR
    ( version BETWEEN '040' AND '050' AND fiscyear = '2008' ).

Regards.

Re: Question about writing code

Former Member — Tue, 10 Jun 2008 21:41:51 GMT

answered