My dbproc fails to
create because the statement "continue execute" is not recognised, with the
error code/message
Error during execution
-->-25010
SQL error -5015 = Missing keyword (error position: 1453)
-->-25010
SQL error -5015 = Missing keyword (error position: 1453)
The fragment causing
the problem is listed below, the proc installs and works fine when "continue
execute" is replaced by any normal sql statement
catch
set ErrorCode = $rc;
set ErrorMsg = $errmsg;
if ErrorCode = 100 then begin
set ErrorCode = $rc;
set ErrorMsg = $errmsg;
if ErrorCode = 100 then begin
continue execute; /*
this statement causes the error below */
end;
subtrans rollback;
stop(ErrorCode, ErrorMsg);
subtrans rollback;
stop(ErrorCode, ErrorMsg);
regards
/alix
###########################################
This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.F-Secure.com/
This does NOT guarantee that the mail is completely virusfree!
Treat ALL E-mails with caution!!!
