Procedure Problem

• shown sunny

  SSC Rookie

  Points: 26

  More actions

  December 8, 2004 at 2:43 am

  #162858

  DEAR Friends,

  I am having a problem with the IF....ELSE condition in the SQL SERVER procedure.

  I am giving the problem part as eg:

  eg:

  IF ((@acno IS NOT NULL) OR (@acno <>'') AND (@actype IS NOT NULL) OR (@actype <>''))

  BEGIN

  PRINT 'hi'

  PRINT ' hello'

  END

  ELSE

  IF ((@acno IS NULL) OR (@acno <>'') AND (@actype IS NOT NULL) OR (@actype <>''))

  BEGIN

  print 'his'

  print 'highness'

  END

  problem

  ======

  WHEN I execute the procedure with inputs as follows

  *********************************************

  exec acno_actype '','CURR'

  *********************************************

  Instead of executing the ELSE condition it executes the IF condition .

  But when I remove the OR condition(ie., acno<>'' ,actype<>'' ) for the IF condition it works perfectly alright.

  Will i be able to know what could be the problem with my IF condition.

  regards

  shown_sunny

• sadheesh kumar m

  Old Hand

  Points: 385

  More actions

  December 8, 2004 at 5:03 am

  #533009

  Try the below code ur missed the bracket for when u using OR:

   

  IF ((@acno IS NOT NULL OR @acno <>'') AND (@actype IS NOT NULL OR @actype <>''))

  BEGIN

  PRINT 'hi'

  PRINT ' hello'

  END

  ELSE

  IF ((@acno IS NULL OR @acno <>'') AND (@actype IS NOT NULL OR @actype <>'')

  BEGIN

  print 'his'

  print 'highness'

  END

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  December 8, 2004 at 5:13 am

  #533012

  I also think that there may be a flaw in your @acno logic.  see the below

  IF ((@acno IS NOT NULL OR @acno <>'') AND (@actype IS NOT NULL OR @actype <>''))

  IF ((@acno IS NULL OR @acno = '') AND (@actype IS NOT NULL OR @actype <> '')

  Try this

  IF ISNULL(@acno, '') <> '' AND ISNULL(@actype, '') <> ''

  IF ISNULL(@acno, '') =   '' AND ISNULL(@actype, '') <> ''

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net

• Yoda-193403

  SSC Eights!

  Points: 988

  More actions

  December 8, 2004 at 7:19 am

  #533028

  Explain (in "pseudo-code", not T-SQL) what you are trying to do.

  Faulty logic that does not work, is all you are showing us.

  Impossible it is, then, to determine your true intent, hm?

• shown sunny

  SSC Rookie

  Points: 26

  More actions

  December 9, 2004 at 4:55 am

  #533160

  Dear Friends,

  I got it right by putting the IF...ELSE condition in the following way.

  ********************************************************

  IF ((@acno IS NOT NULL) AND (@acno ''))

  AND ((@actype IS NOT NULL) AND (@actype ''))

  BEGIN

  PRINT 'both parameters filled in'

  END

  ELSE

  IF ((@acno IS NULL) OR (@acno = ''))

  AND ((@actype IS NOT NULL) AND (@actype ''))

  BEGIN

  print 'Only @actype filled in'

  END

  *********************************************************

  Thank u very much for the help.

  regards

  shown_sunny