Tim.

>>Can you send me your database catalog along with this one table's files
>>(.edbtbl, .edbidx, and .edbblb) ?  I'd like to run this here and see what's
>>going on.

You have database in your mail.

Thank's.

Francisco,

<< You have database in your mail. >>

I'm not seeing any issue with 2.05 B4 - queries for both a sensitive and
insensitive result set return 1 row.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim.

>>I'm not seeing any issue with 2.05 B4 - queries for both a sensitive and
>>insensitive result set return 1 row.

Yes, this is the problem, if you check row you can see that field EXIST=0 and a part of the query is EXIST>0

Francisco,

<< Yes, this is the problem, if you check row you can see that field EXIST=0
and a part of the query is EXIST>0 >>

My apologies - I got it reversed.  How did you update this column and what
version of Delphi are you using ?

If I NULL the column value using the EDB Manager, and then re-enter it as 0,
then the query works, so I'm thinking that there may be an issue with how
the column is initially populated.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim.

I work with Delphi 2007. This table is managed by triggers on tables COMPRASLINEAS and VENTASLINEAS. I think that the problem can be that field EXIST in table LOTES is decimal scale 2 and the fields that add and subtract this field in tables COMPRASLINEAS and VENTASLINEAS is decimal scale 3 and in VENTASLINEAS are a row with 3 decimals in field CANTIDAD. I will resize field EXIST in table LOTES to decimal scale 3.

Francisco,

<< I work with Delphi 2007. This table is managed by triggers on tables
COMPRASLINEAS and VENTASLINEAS. I think that the problem can be that field
EXIST in table LOTES is decimal scale 2 and the fields that add and subtract
this field in tables COMPRASLINEAS and VENTASLINEAS is decimal scale 3 and
in VENTASLINEAS are a row with 3 decimals in field CANTIDAD. I will resize
field EXIST in table LOTES to decimal scale 3. >>

EDB should be handling this properly and rounding any assignments to the
EXIST column properly, even if the source data is using a larger scale.  Is
it possible that this data was in their from quite a while ago ?  The reason
that I ask is that we did have an issue very early on with EDB with respect
to properly rounding DECIMAL/NUMERIC column values during assignments.

I'll do some more playing around here to see if I can replicate this.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim.

>>EDB should be handling this properly and rounding any assignments to the
EXIST column properly, even if the source data is using a larger scale.  Is
it possible that this data was in their from quite a while ago ?  The reason
that I ask is that we did have an issue very early on with EDB with respect
to properly rounding DECIMAL/NUMERIC column values during assignments.<<

No, this customer is working at the begin with this EDB build.

Thank's

Francisco,

<< No, this customer is working at the begin with this EDB build. >>

Okay, I'll make sure that I test this before the next build goes out.
Somewhere an invalid value is creeping in, but initial checks don't turn up
anything - everywhere that assigns a value is rounding the value to the
proper scale.

--
Tim Young
Elevate Software
www.elevatesoft.com

Francisco,

Just to let you know that this has been fixed for 2.05 B5:

http://www.elevatesoft.com/incident?action=viewrep&category=edb&release=2.05&incident=3413

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim.

>>Just to let you know that this has been fixed for 2.05 B5:

Ok. Thank's and regards.