3 Replies Latest reply: Mar 24, 2014 2:54 AM by Sushil Kumar RSS

    IF Else Condition?

    Helen Betty

      HI, help me to write in QV Scripting....

       

      if(service_type==CPE)

      {

        SQL Select Stmt...

        

          if(Value>0)

           {

        SQL select Stmt...

       

        If (No data)

         {

           SQL select Stmt..

         }

            }

        else

                  {

        SQL select Stmt..

              If (No data)

                {

                   SQL select Stmt..

                }

            }

      }

       

      Thanks,

      Helen

        • Re: IF Else Condition?
          Nitin Gupta

          if(service_type='CPE') then

           

            SQL Select Stmt...

           

             elseif(Value>0) then

           

            SQL select Stmt...

           

          else If (No data) then

           

               SQL select Stmt..

           

            else

                   

            SQL select Stmt..

                 elseifIf (No data) then

           

                       SQL select Stmt..

          • Re: IF Else Condition?
            Neha Rangari

            IF service_type='CPE'

            THEN

              SQL Select Stmt...

             

                IF Value>0

                 THEN   

              SQL select Stmt...

             

              IF (No data)

               THEN

                 SQL select Stmt..

              

              ELSE

              SQL select Stmt..

                    IF (No data)

                     THEN

                         SQL select Stmt..

                     ENDIF

                ENDIF

              ENDIF

            ENDIF

            • Re: IF Else Condition?
              Sushil Kumar

              Hi Helen,

               

              Try this:

               

              IF service_type='CPE' THEN

                SQL Select Stmt...

               

              IF Value>0     THEN  

                SQL select Stmt...

               

              IF isnull(field name)   THEN

                   SQL select Stmt.

              ELSE

                SQL select Stmt..

                      IF isnull(field name)    THEN

                           SQL select Stmt..

                       ENDIF

                  ENDIF

                ENDIF

              ENDIF;

               

               

              HTH

              Sushil