Subject | Prepare + unprepare + close with IB_Query or IB_Cursor? |
---|---|
Author | pepmallorca |
Post date | 2002-03-23T12:41:50Z |
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,
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,