Embdedded SQL : Execute 2 instructions on WHENEVER

From: LeguMan <leguman_at_hotmail.com>
Date: Wed, 11 Apr 2001 12:16:49 +0200
Message-ID: <3ad42e17$0$186$456d72a3_at_news.skynet.be>


Hello

How can i execute two instructions when a do a

EXEC SQL WHENEVER NOT FOUND DO <action>;

I would like to run error("No Row Found") and return(-1)

I try this but don't work

EXEC SQL WHENEVER NOT FOUND DO
{
error("No Row found");
retrurn(-1);
}

PS : For several resons a could not use a sqlcode test ...

Thanks
LeguMan Received on Wed Apr 11 2001 - 12:16:49 CEST

Original text of this message