pepmallorca,

AFAIK, there is no need to call unprepare and close.

Luiz.

----- Original Message -----
From: "pepmallorca" <pepmallorca@...>
To: <IBObjects@yahoogroups.com>
Sent: Saturday, March 23, 2002 9:41 AM
Subject: [IBO] Prepare + unprepare + close with IB_Query or IB_Cursor?


> Hello:
>
> If I have a IB_Query1 or a IB_Cursor using like this:
>
> with IB_Query1 do
> begin
> sql.clear;
> sql.text:='';
> sql.text:='select a,b from sss where a=:pa';
> ...
> prepare;
>
> params[0].AsString:='xxx';
> first
> while not eof...
> ...
> end
> end;
>
> with IB_Query1 do
> begin
> sql.clear;
> sql.text:='';
> sql.text:='select a,b from hhhh where a=:pa';
> ...
> prepare;
>
> params[0].AsString:='xxx';
> first
> while not eof...
> ....
> end
> end;
>
>
> Is need to use UNPREPARE, and CLOSE to avoid problems... or use it
> optional?
>
> Thanks,
>