> -----Original Message-----
> From: dale tabbert [mailto:adonai@...]
> Sent: Martes 23 de Enero de 2001 0:22
>
> I have a IB_DSQL (the sp only returns one row so I used
> this component) with the SQL of
> "Select * from ADD_Directory
> (:Directory_Type, :Directory_Class, :parent_id,
> :supervisor_id, :description, :email, :name)"
> The stored procedure returns the ID (integer) of the new object.
> This GPF is happening in an ASTA Business Object when I call
> ExecSQL.

Generally speaking, this approach is wrong. If you want to get data, don't
use TIB_DSQL, it's mostly to send commands. You can use a TIB_Cursor,
prepare the same statement shown above and call the First method of the
TIB_Cursor. Since you only get one record, you don't need buffering. You can
recover your result after calling First. Be sure to check for EOF before
trying to get data.

C.