Hello,

I'm in trouble in an operation envolving float values. I'm using
Delphi 5 with Interbase 6.0. The problematic routine is:

With Query1 do
begin
first;
while not eof do
begin
Query2.ParamByName('codigo').asstring:=fieldbyname
('IE_produto').asstring;
Query2.prepare;
Query2.open;
Query2.edit;
Query2.fieldbyname('PR_customedio').asfloat:=
(Query2.fieldbyname('PR_saldo').asfloat*
Query2.fieldbyname('PR_customedio').asfloat)+
(fieldbyname('IE_qtdereal').asfloat*
fieldbyname('IE_precocompra').asfloat)/
(Query2.fieldbyname('PR_saldo').asfloat+
fieldbyname('IE_qtdereal').asfloat);
Query2.post;
Query2.close;
next;
end;
end;

All the envolved fields in the above calculation are defined like
DOUBLE PRECISION fields. I'm using two TIBQuery connected to two
TIBUpdateSQL.
The problem is that sometimes it works perfectly, sometimes not. It
raises an error "Invalid pointing operation/conversion". I debuged the
program and saw that sometimes some of these operators are not with the
values they should have. Once, one of these operators show the value "
-NAV".
What I have to do ? Should I define these fields as another Interbase
type instead DOUBLE PRECISION ? What is the most trustable type for
floating values ? Am I using the better syntax in Delphi ? Please, help
me...

Thank you in advance,

Paulo Albuquerque de Barros Júnior
paulo.albuquerque@...