Hello Helen,

I should have explained better...

> >Should EXECUTE PROCEDURE be supported in
> >a TIBODataset? Given that's DSQL, and the call is
> >supported in DSQL from what I can read, how should
> >this work?
>
> SQL: 'EXECUTE PROCEDURE BLAH(:PARAM1, :PARAM2)
>
> Just call ExecSQL. If there are return values, read Fields[]

In Database Workbench, someone wants to execute a procedure and
see the results. Now, this can be done via "Run" on a procedure, but
this customers says that this is supported in DSQL, so it should work
from the SQL Editor. The SQL Editor has a grid in which it can
display result sets.

But as far as I can see, EXECUTE PROCEDURE ...
RETURNING_VALUES doesn't do a resultset.

If I would be writing this:
EXECUTE PROCEDURE FOO (:p1) RETURNING_VALUES :p2

would that work? Would "p2" get the value?

> TIBOStoredProc is also a TIBODataset descendant. Use ExecProc there.
>
> But why would you use a dataset component at all, when you could use

TIB_DSQL?

Because it's linked to a 3rd party grid via the "dataset" property :)

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com