Hi Guys,

Hoping someone can help. I am having an issue with a custom query trying to write to Sage. 

I have assigned a BSB token value and set this as integer (or number)

and then try my custom query:

but I get this error in the workflow.

Any ideas how to resolve this?

I had tried an insert query previous to this but I get a type mismatch as the BSB column is a decimal and any token tags set would not work. Also this is an ODBC connection, not possible for a direct connection.

Also, if I hardcode the value in the custom query it works.

Thanks

Tina