Luiz,

It improved very, but still he is slower of the paradox,

paradox: 2:58,
ibo: 5:20

if the time will be normal biggest, ok

thanks...

Fabio Lobo

----- Original Message -----
From: Luiz Alves
To: IBObjects@yahoogroups.com
Sent: Friday, January 18, 2002 3:30 PM
Subject: Re: [IBO] Insert problem...


You continue not using static references to the columns as:
> ibDsqlEcon3v.parambyname('cartao').asInteger :=
tbEconv3.fieldbyname('cartao').asInteger;

You could to do:
var tbcartao:tib_column;

....
...
if not ibDsqlEcon3v.Prepared then
ibDsqlEcon3v.Prepare;
tbcartao:=ibDsqlEcon3v.parambyname('cartao');
....
While not tbEconv3.Eof do begin
tbcartao.asInteger := tbEconv3.fieldbyname('cartao').asInteger;
/*if you can use also static references to
tbEconv3.fieldbyname('cartao')*/
....
ibDsqlEcon3v.ExecSQL;
...
...
end;
...
...


Luiz.


___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]