Is there a way to get EDB Manager to show a result set when executing a
script?

John

John ,

> Is there a way to get EDB Manager to show a result set when executing a
> script?

Do you mean something like this:

SCRIPT
BEGIN
  DECLARE RESULT CURSOR with return for stmt;
  Prepare stmt from
  'select * from mytable';
  Open result;
END

Uli

John,

<< Is there a way to get EDB Manager to show a result set when executing a
script? >>

Sure.  What you want is the WITH RETURN clause as part of the DECLARE
statement for the cursor:

http://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=DECLARE

Uli gave a good example in his post.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thanks Uli & Tim.

John