How to change the data type of a value fetched in DataQuery

[Goutham]

Problem: Customer wants to SET and Declare a variable in the DataQuery or change the datatype of an existing field retrieved from the DataQuery

Solution: SET and Declare function is not supported in the DataQuery, but the CAST function is supported.

For example, "Select cast( Id as varchar) from Invoice"

The above query will convert the value of the field “Id” into varchar datatype.

[sayam]

Thanks Goutham,

I had this issue. was looking forward to this solution.