Apex Intermediate Progress | ( Lessons)

Lesson: 07 QueryException

Notes
Video

Notes

Any problem with SOQL queries, such as assigning a query that returns no records or more than one record to a singleton sObject variable.

This statement doesn't cause an exception, even though we don't have a Account with name='XYZ'.
The list lm will just be empty.

try {
    List<Account> lm = [SELECT Name FROM Account WHERE Name = 'XYZ'];

} catch(QueryException qe) {
    System.debug('The following exception has occurred: ' + qe.getMessage());    
}

However, this statement causes a QueryException because we're assigning the return value to a Account object but no Account is returned.

try {
    Account m = [SELECT Name FROM Account WHERE Name = 'XYZ' LIMIT 1];

} catch(QueryException qe) {
    System.debug('The following exception has occurred: ' + qe.getMessage());    
}

DEBUG|The following exception has occurred: List has no rows for assignment to SObject

The following statement also will cause exception when there are more Accounts with the name XYZ

try {
    Account m = [SELECT Name FROM Account WHERE Name = 'XYZ'];

} catch(QueryException qe) {
    System.debug('The following exception has occurred: ' + qe.getMessage());    
}

DEBUG|DEBUG|The following exception has occured: List has more than 1 row for assignment to SObject

Prev You need to login to have access to the quizzes. Next

Mastered by 66 users.

Apex Intermediate

A. Apex DML Operations (8 lessons)

B. Apex Classes (17 lessons)

C. Apex Triggers (9 lessons)

D. Apex Exceptions (11 lessons)

E. Asynchronous Apex (6 lessons)

F. SOSL (10 lessons)

G. Testing Apex (9 lessons)

H. Apex Fast Recap (142 lessons)

I. Build Apex Coding Skills (64 lessons)

J. Miscellaneous (17 lessons)

You need to complete all the quizzes before certification.

Go to top

Login to your account

Lesson: 07 QueryException

Notes

Apex Intermediate