Re: Stored Procedure: Check For No Rows Found

Oops... Sorry about the truncated posting! DEFINE magic INTEGER; LET magic = 0; FOREACH SELECT name INTO v_name FORM table_x WHERE x_key = p_key LET magic = 1; END FOREACH IF magic = 0 THEN -- You know you didn't find anything END IF There may be a better way of doing it; this does work. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> >From: pcarter@hpcc01.corp.hp.com (Preston Carter) >Date: Fri, 28 Jun 1996 02:41:12 GMT >X-Informix-List-Id: <news.25524> > >OK, I give up. In a stored procedure how do you find out if there are >no rows found? > >Suppose I have the following code: > > SELECT name > INTO v_name > FROM table_x > WHERE x_key = p_key;> >What do I write after that to check if there is no matching row? >Thanks.