IF Else Condition?

[#1]

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

[Anonymous]

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..

[#3]

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

[sushil353]

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