temp=GetDataType(Result.FieldNativeDataType(i))
Function GetDataType(typeConst As Integer) As String
Select Case typeConst
Case SQL_CHAR : GetDataType = “CHAR”
Case SQL_NUMERIC : GetDataType = “NUMERIC”
Case SQL_DECIMAL : GetDataType = “DECIMAL”
Case SQL_INTEGER : GetDataType = “INTEGER”
Case SQL_SMALLINT : GetDataType = “SMALLINT”
Case SQL_FLOAT : GetDataType = “FLOAT”
Case SQL_REAL : GetDataType = “REAL”
Case SQL_DOUBLE : GetDataType = “DOUBLE”
Case SQL_DATE : GetDataType = “DATE”
Case SQL_TIME : GetDataType = “TIME”
Case SQL_TIMESTAMP : GetDataType = “TIMESTAMP”
Case SQL_VARCHAR : GetDataType = “VARCHAR”
Case SQL_BINARY : GetDataType = “BINARY”
Case SQL_VARBINARY : GetDataType = “VARBINARY”
Case SQL_LONGVARCHAR : GetDataType = “LONGVARCHAR”
Case SQL_LONGVARBINARY : GetDataType = “LONGVARBINARY”
Case SQL_BIGINT : GetDataType = “BIGINT”
Case SQL_TINYINT : GetDataType = “TINYINT”
Case SQL_BIT : GetDataType = “BIT”
End Select
End Function
temp = -9 is not defined in GetDataType and so
temp2=Result.getvalue(i) go to error and the message is Cannot convert data from native to expected or requested datatype.
DB MS SQL and item table is string!!!
bye bye JZ