


Hi,
In update data activity, I'm getting below error:
ODB-240000 ODBC error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Argument data type smallint is invalid for argument 1 of substring function. SQLState: 37000
Here source field has short datatype and destination has string datatype.
Using ToString(), I tried to convert short to string but its not working.
Please let me know how to resolved the issue.
Thanks
Views
Replies
Sign in to like this content
Total Likes
Hi,
Are you using ToString() inside the Substring, and offset counting from 1?
Substring(ToString(@short), 1, 1) works fine in postgres, translates to Substr(text(X0.iShort), 1, 1)
Thanks,
-Jon
Hi,
Are you using ToString() inside the Substring, and offset counting from 1?
Substring(ToString(@short), 1, 1) works fine in postgres, translates to Substr(text(X0.iShort), 1, 1)
Thanks,
-Jon