If you are returning rows and you want to maintain a prepared state
executing over and over, put a SUSPEND in the body of it and use the
TIB_Cursor component with a SELECT statement. This will get you past a bug
in the IB API where remote connections are concerned. If it weren't for this
bug TIB_DSQL would be ideal.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Christian Gütter" <cguetter@...>
To: <ibobjects@yahoogroups.com>
Sent: Thursday, February 01, 2001 10:54 AM
Subject: [IBO] TIB_StoredProc or TIB_DSQL?


> Hi,
>
> which component is better to execute a stored proc
> which returns a single row?
>
> I used to use the TIB_StoredProc, but the IBO help says
> about TIB_DSQL: 'It is ideal for executing a stored procedure,
> doing a large batch of record inserts, performing DDL or DML
> statements, etc.'
>
> Any comments or experiences?
>
>
> TIA,
>
>
> Christian
>
>
>
>