I have a field in my SQL table that is defined as varchar(8000). Some fields are numbers which I want to use in some calculations in ReportNet.
I am trying to typecast the text field to float and tried to validate it. But it quits with the following error - QE-DEF-0149 Invalid query specification. Wrong expression type.
Same is the case with any function I try to use. I thought that varchar(8000) was the issue and hence tried a different field from the table, and have the same error. Anyone has any thoughts on that? Thanks.
I am trying to typecast the text field to float and tried to validate it. But it quits with the following error - QE-DEF-0149 Invalid query specification. Wrong expression type.
Same is the case with any function I try to use. I thought that varchar(8000) was the issue and hence tried a different field from the table, and have the same error. Anyone has any thoughts on that? Thanks.