TIB_DSQL used to produce an exception if no row was returned or more than
one row was returned. I prefer to use TIB_Cursor and close it explicitly (or
use the AfterFetchEof event when I set AutoFetchAll to true and call here
AbortFetching and Close).

C.

> -----Original Message-----
> From: dennis@... [mailto:dennis@...]
> Sent: Viernes 23 de Febrero de 2001 4:06
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Prepare Question
>
>
> At 08:44 AM 02/23/2001 +0100, you wrote:
> >Isn't there a bug associated with SELECTs in DSQLs? Wouldn't it be
> >neccessary to rather use TIB_Cursor (or UnPrepare/Prepare
> between each time
> >you call your TIB_DSQL)?
>
> You are probably thinking of the bug in InterBase with respect to serial
> calls to a stored procedure which returns data. The prepare/unprepare
> tactic is a way to avoid that problem. There is NO BUG in
> TIB_DSQL related
> to this (or related to anything else, I dare say).
>
> Dennis McFall
>
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>