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>
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