M
Mr. x
Hello,
I use web-service, and also access for my database, and VB as my script of
web-service, and oleDBConnection to connect to database.
When I do query like this :
"select col1, col2, col3, ... from myTable"
....
mark = dr.getInteger(0) ' dr is the data-reader component.
....
.... everything works fine,
but when I do a query as follows :
"select col1 + 10, col2, col3, ... from myTable"
....
mark = dr.getInteger(0) ' dr is the data-reader component.
....
.... and trying running the query I get the following message :
'The data value could not be converted for reasons other than sign mismatch
or data overflow. For example, the data was corrupted in the data store but
the row was still retrievable".
What should I do in order to make things work on calculated fields ?
Thanks
I use web-service, and also access for my database, and VB as my script of
web-service, and oleDBConnection to connect to database.
When I do query like this :
"select col1, col2, col3, ... from myTable"
....
mark = dr.getInteger(0) ' dr is the data-reader component.
....
.... everything works fine,
but when I do a query as follows :
"select col1 + 10, col2, col3, ... from myTable"
....
mark = dr.getInteger(0) ' dr is the data-reader component.
....
.... and trying running the query I get the following message :
'The data value could not be converted for reasons other than sign mismatch
or data overflow. For example, the data was corrupted in the data store but
the row was still retrievable".
What should I do in order to make things work on calculated fields ?
Thanks