# Can't write float/double tags below a given value?

**URL:** <https://forum.inductiveautomation.com/t/cant-write-float-double-tags-below-a-given-value/17804>\
**Category:** Ignition\
**Created:** [April 23, 2018, 1:17pm UTC](https://forum.inductiveautomation.com/t/cant-write-float-double-tags-below-a-given-value/17804 "2018-04-23T13:17:42Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![automatisation](https://avatars.discourse-cdn.com/v4/letter/a/94ad74/32.png) [@automatisation](https://forum.inductiveautomation.com/u/automatisation)\
**Post date:** [April 23, 2018, 1:17pm UTC](https://forum.inductiveautomation.com/t/cant-write-float-double-tags-below-a-given-value/17804/1 "2018-04-23T13:17:42Z")

</div>

I’m trying to put a decimal(10,5) from a MySQL database to a Float4 or Float8 tag and as soon as my value is below 0.0001 (eg: 0.00002), the write can’t complete.

While trying stuff around, I also found a strange behavior (Ignition 7.9.5 just in case) :  
Create a Float4 or Float8 tag  
Create a Numeric Textfield bounded bi-directionnaly to the tag  
Enter 2e-3 \>\> OK  
Enter 2e-5 \>\> OK  
Enter 2e-7 \>\> Forfeit

Enter 2e-3 \>\> OK  
Enter 2e-7 \>\> OK  
Enter 2e-5 \>\> Forfeit

One time, the 2e-5 is ok but not the other time. Same goes for 2e-7. Strange.

I know computers have issue with numbers not being ^2 based and I guess this is related to that. Sadly it seems Ignition does not offer a numeric type equivalent to MySQL decimal(x,y) type.

The only workaround I found so far (apart multiplying all my values from MySQL) is writing my value to a String tag and then casting it to a Double tag. Even though it works, I don’t find it “clean”.  
If anyone has another idea, I’d be delighted to hear about it.  
Thanks

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [April 23, 2018, 1:23pm UTC](https://forum.inductiveautomation.com/t/cant-write-float-double-tags-below-a-given-value/17804/2 "2018-04-23T13:23:34Z")

</div>

Have you tried changing the Deadband value on the tag?

---

<div class="post-metadata">

**Author:** ![automatisation](https://avatars.discourse-cdn.com/v4/letter/a/94ad74/32.png) [@automatisation](https://forum.inductiveautomation.com/u/automatisation)\
**Post date:** [April 23, 2018, 1:39pm UTC](https://forum.inductiveautomation.com/t/cant-write-float-double-tags-below-a-given-value/17804/3 "2018-04-23T13:39:28Z")

</div>

Ha damn, didn’t see that 😄  
Guess it was a PIBCAK again !  
Thanks a lot.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [April 23, 2018, 2:00pm UTC](https://forum.inductiveautomation.com/t/cant-write-float-double-tags-below-a-given-value/17804/4 "2018-04-23T14:00:03Z")

</div>

> [@automatisation](#):
>
> Ignition does not offer a numeric type equivalent to MySQL decimal(x,y) type

Well, Ignition is built on Java, and Java has [BigDecimal](https://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html).