| List: | MySQL and Java | « Previous MessageNext Message » | |
| From: | Igor Dayen | Date: | April 25 2004 8:57pm |
| Subject: | What is SQLSTATE for indicating empty result set? | ||
| View as plain text | |||
In the stored procedure fragment below there is a need to make some decision if table is empty. DECLARE CONTINUE HANDLER FOR SQLSTATE xxxxxx SET EMPTY_SET = 1; SELECT * FROM SOME_TABLE; IF EMPTY_SET=1 THEN ............ What is correct SQLSTATE for indicating this? Is there any SQLCODE reserved for this? Thanks very much.
| Thread | ||
|---|---|---|
| • What is SQLSTATE for indicating empty result set? | Igor Dayen | 25 Apr |
| • Re: What is SQLSTATE for indicating empty result set? | Paul DuBois | 25 Apr |
| • Re: What is SQLSTATE for indicating empty result set? | Igor Dayen | 25 Apr |
