Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Field out of range
Tue, May 4 2010 6:22 AMPermanent Link

Jose Eduardo Helminsky

HPro Informatica

Hi everyone

Sometimes one of my applications are showing the message "Field 'TOT' is out
of range".

The operation in question is only reading records. The same operation works
so good when I put some values on it. But sometimes I need to put zero on
some fields, including the field TOT. I am pretty sure, at least when I see
the data using DBSYS, that the content of the field TOT is 0. The datatype
is BCD. There is no constraints related with limits.

I am using DBISAM 4.29 build 1 and I repeat the same operation user does in
my office but the problem does not appear. Is there some tip on how can I
catch this error ? The only thing that is coming up to my mind is to put a
lot of MessageBox during the process and see exactly where the error is
happening but I would prefer this option was the last one.

Thanks for any tip.

Eduardo

Tue, May 4 2010 1:39 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Eduardo,

<< Sometimes one of my applications are showing the message "Field 'TOT' is
out of range". >>

There isn't any error message that matches what you describe exactly.

Are you seeing 'Value of field TOT is out of range' ?  If so, and TOT is a
BCD field, then this error is caused by the value in the field not being a
valid BCD number, and this can happen during assignment or retrieval.

Can you get this to happen when running the application in the IDE ?  If so,
then you can see the complete call stack by making sure to compile with Use
Debug .DCUs in your project compiler options.

--
Tim Young
Elevate Software
www.elevatesoft.com
Tue, May 4 2010 3:08 PMPermanent Link

Jose Eduardo Helminsky

HPro Informatica

Tim

> Are you seeing 'Value of field TOT is out of range' ?  If so, and TOT is a
> BCD field, then this error is caused by the value in the field not being a
> valid BCD number, and this can happen during assignment or retrieval.
Yes, this is exactly what I am seeing.

> Can you get this to happen when running the application in the IDE ?
Unfortunatelly no. I am trying to reproduce the problem here but nothing
until now.

I will double check the assignments to the TOT field and see if I can find
something.

BTW
Thanks for your tip. When I discover the problem I wll let you know.

Eduardo

Image