sql from integer to real

I still get

Code: Select all

   SQL Logger                      modifying column "pi_00_distance" type of table device_history_51480417 ("beacon-ble bug ") from integer to REAL


with state def:

Code: Select all

         <State id="Pi_00_Distance">
         <ValueType>Float</ValueType>
         <TriggerLabel>Pi_00_Distance</TriggerLabel>
         <ControlPageLabel>Pi_00_Distance</ControlPageLabel>
         </State>


that should not happen anymore w indigo 7.5?
What am I doing wrong (lower case float) ?

Karl

[matt (support)]

Is this for an existing device or a new one? The state info in the XML is only used when a device is newly created.

A new device


Sent from my iPhone using Tapatalk

[matt (support)]

The case of "Float" doesn't matter. I tested it creating a new device then immediately dumped to the Event Log the states dict and it showed as a float. Is it possible your plugin is updating the state back to integer somewhere?

Converting back to int? How?

There is No xml stuff in plugin.py
Storing an int value would do it?


Sent from my iPhone using Tapatalk

[matt (support)]

Storing an int value would do it?

Yes, updating states is dynamic and will change the type based on the new value type passed in to the update call.

yes that was it: initialized with 99999 instead of 99999.

works fine now

thanks

Karl