#1  
Old 18th June 2019, 11:16 AM
Sue King
 
Posts: n/a
Default Using exit in a stored procedure

Greetings,

According to Mantis, #0001938 added an 'exit' statement to stored
procedures.

In 4.5013 I am trying to use this. However when I execute the
procedure code to add it, EM is generating an error, Query Preparation
Failed, $3CA0/15520 with the cursor position between exit and the ;

if condition then
set out_value = -1;
exit;
endif;

There is nothing in the manual about how to use 'exit'.

Am I using it incorrectly? Or is there a problem with the SQL parser ?

Sue
  #2  
Old 18th June 2019, 02:25 PM
Eivind Bakkestuen [NDD]
 
Posts: n/a
Default Re: Using exit in a stored procedure

> In 4.5013 I am trying to use this. However when I execute the
> procedure code to add it, EM is generating an error, Query Preparation
> Failed, $3CA0/15520 with the cursor position between exit and the ;


It appears this is a regression; I'll reopen the issue. Thanks for the
report.

--
Eivind Bakkestuen [NDD]
  #3  
Old 19th June 2019, 07:25 AM
Sue King
 
Posts: n/a
Default Re: Using exit in a stored procedure

Eivind Bakkestuen [NDD] wrote:

> > In 4.5013 I am trying to use this. However when I execute the
> > procedure code to add it, EM is generating an error, Query
> > Preparation Failed, $3CA0/15520 with the cursor position between
> > exit and the ;

>
> It appears this is a regression; I'll reopen the issue. Thanks for the
> report.


My pleasure.


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Over head with Stored procedure David Rose nexusdb.public.support.sql 1 11th February 2016 02:28 AM
Stored procedure timeout Sue King nexusdb.public.support 24 11th January 2016 12:03 AM
Stored procedure and starttrasactionwith Chris Schofield nexusdb.public.support 7 22nd December 2011 12:00 AM
Name of Stored Procedure / Stored Function in TnxStoredProc mustbe exact case! Ad Franse nexusdb.public.support.sql 0 9th February 2010 12:13 AM
Help with Stored procedure Chris nexusdb.public.support.sql 0 25th July 2005 03:53 AM


All times are GMT +11. The time now is 06:46 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.