Hi all,
How can there be a negative zero [-0] ? I have a basic calc field which
produced this but only for certain records. On deleting the offending records the problem went away so apparently the records somehow got corrupted. This wrecked havok with some error traps I had in place and spent quite a while trying to figure out the problem. Deleting records, for me at least, is pretty much a last resort as I would much rather find a cause and fix it so as to be able to prevent them from happening in the first place.
The filter was basically on the order of:
Calc=A_Total_field - Another_Calc_field
I had also replaced the "Another_Calc_field" with the actual fields used to create it (such as total_of_field1 - total_of_field2, etc) with the same -0 result.
This did occur fairly soon after my Form Properties Order filters corrupted and either went blank or had the word "Table" for the Order Filter---something that has happened now about 6 times in the last few months with no known cause.
Could these two things be related in some strange way?? Can't see how and might just be confusing the scenario by mentioning it.
Any thoughts regarding these two situations as far as cause or if you have had similar problems would be great...I had already mentioned the latter in a prior thread but noone answered so may just be me!!! :)
How can there be a negative zero [-0] ? I have a basic calc field which
produced this but only for certain records. On deleting the offending records the problem went away so apparently the records somehow got corrupted. This wrecked havok with some error traps I had in place and spent quite a while trying to figure out the problem. Deleting records, for me at least, is pretty much a last resort as I would much rather find a cause and fix it so as to be able to prevent them from happening in the first place.
The filter was basically on the order of:
Calc=A_Total_field - Another_Calc_field
I had also replaced the "Another_Calc_field" with the actual fields used to create it (such as total_of_field1 - total_of_field2, etc) with the same -0 result.
This did occur fairly soon after my Form Properties Order filters corrupted and either went blank or had the word "Table" for the Order Filter---something that has happened now about 6 times in the last few months with no known cause.
Could these two things be related in some strange way?? Can't see how and might just be confusing the scenario by mentioning it.
Any thoughts regarding these two situations as far as cause or if you have had similar problems would be great...I had already mentioned the latter in a prior thread but noone answered so may just be me!!! :)
Comment