Hi,

I don't know if this is a good place to ask this but I have a problem
that goes like this:

I have created a proc (Proc A) that will call another proc (Proc B -
simply using an execute).

At the end of proc B is has a select where it selects 2 column values
from a table. I believe this proc is used in a C++ application to
return to a grid or something.

What i'd like to do is be able to return to my calling proc (Proc A)
and be able to use these values. Problem is I can do this with OUT,
but do not want to change the original procs... Is there any way in
Proc A that I can capture the select values from Proc B?

Thanks!

Depending upon which version of SQL Anywhere you have, you can execute a
SELECT based on a stored procedure. As in:

Select T.col1, T.col2
into myVar1, myVar2
from procB (arg1, arg2, arg3) as T ;

Paul Horan[TeamSybase]

"Soulless" <dgmsalter (AT) gmail (DOT) com> wrote