Named query to insert float to sql, error unable to coerce to number

Ignition
1

I have a named query to insert a record into a sql database table
One of the data types in the table is float. In the Parameters portion of the named query I have tried Float4 and Float8
In the button that triggers the named query the applicable part is
ValueA = [tagpath]
system.db.runNamedQuery([NamedQryName], {“Value1”:ValueA,})

The tag datatype is also set to float

When the named query is executed, I get the error: Error trying to coerce [tagpath] to a number.
It is already a float (number).

2

try this
ValueA = system.tag.read([tagpath]).value

2 Likes
3

Thank - you. That fixed it.

5

I haven’t switched or begun to mess with Ignition 8 yet. Maybe someone else can chime in.