[Blog bot]

Источник: http://kamalblogs.wordpress.com/2010...d-declaration/
==============

Do you know when we use select statement for conditional checks, we don’t need to declare a variable if we use the same name as the table. Look at the example below to understand better.

static boolean SelectStatementInBooleanConditions() 
{
    //no declaration for table object has been made.     
    boolean test;     ;      

    //testing a variable     
    test =  (select firstonly salesTable).salesId ? true : false;      

    //if condition     
    if ((select firstonly salesTable).recid)     
    {         
        return true;     
    }
      
    //switch statement     
    switch ((select firstonly salesTable).recid)     
    {  
        case 0:             
            return true;         
        case 1:             
            return false;         
    default:             
            return false;     
    }      

    //return statement     
    return ((select firstonly salesTable).recid); 
}

In standard you can find similar usage extensively in exists methods. This can make your code smarter and simpler
Run the job and see that you dont get any errors……