SQL Anywhere database - Exit a procedure before complete

Author

Exit a procedure before complete

Jim Diaz

2005-04-22, 7:23 am

When calling a procedure that is expected to take a while is it possible to
return control to the calling procedure or application before it is
complete? Version 6.0.3

Thanks

Jim

Stephen Rice

2005-04-22, 1:23 pm

Not that I have ever heard of, but maybe using an event would do the job
since events execute asynchronously (but they are on their own connection so
that may not be ok)

/steve
--
Stephen Rice
Technical Services Manager
iAnywhere Solutions
------------ Please Post -------------
"Jim Diaz" < jimdiazatemprisecorp
orationdotcom> wrote in message
news:4268eb27$1@foru
ms-2-dub...
> When calling a procedure that is expected to take a while is it possible
> to return control to the calling procedure or application before it is
> complete? Version 6.0.3
>
>
> Thanks
>
> Jim
>

Graeme Perrow

2005-04-22, 8:23 pm

Stephen Rice wrote:
> Not that I have ever heard of, but maybe using an event would do the job
> since events execute asynchronously (but they are on their own connection so
> that may not be ok)

Note, however, that events were not available until version 8.0.

--
Graeme Perrow
Senior Software Developer
gperrow _at_ ianywhere _dot_ com
iAnywhere Solutions Inc.
A Sybase company

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer/

Graeme Perrow

2005-04-22, 8:23 pm

Graeme Perrow wrote:
> Stephen Rice wrote:
>
>
>
> Note, however, that events were not available until version 8.0.
>

My mistake - events were added in version 7.0. Either way, they weren't
there in 6.0.

--
Graeme Perrow
Senior Software Developer
gperrow _at_ ianywhere _dot_ com
iAnywhere Solutions Inc.
A Sybase company

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer/

Sponsored Links