Hi
I have an app which has two Dbase tables in a master/detail scenerio.
The master has a current balance field of a field in the details table.
This is occasionally incorrect due to trying to add or subtracting due
to detail changes.
I therefore have reconcilation procedure which then goes and
recalculates the current balance for all master records.
The problem I have is that of the records that are wrong, ie the total
to the detail records don't equal the master, there are a number which
show in my list of differences where the values are the same i.e.
Details total 833.40 and master equals 833.40.
The database fields are numeric with 8 digits and 2 decimals. The show
as TFloatfields against the database. The variable I am using in the
procedure to add up to detail values is real so I am confused on why
this might be. I have tried various ways to get around it such as using
extended, converting the fields to strings and back again and still they
show that the two numbers are different.
Any ideas
Eion McIntosh
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
