Troubleshooting
Problem
This technote explains how to resolve a SQLBasic Runtime error '440' : "Object method returned an unsupported data type" error that can occur when IBM® Rational® Robot attempts to retrieve numeric data column information from the table in Microdost® SQL Server.
Symptom
The SQLBasic Runtime error '440': "Object method returned an unsupported data type" appeared when the execution of a GUI script attempts to retrieve numeric data column information from the table in the SQL Server database using SQL commands or ADODB functionality.
Cause
This error occurs if the data type that specifies what type of information is stored in the column is of type "BigInt". SQL Server came out with the new data type BigInt. This 64-bit datatype solves the problem of values that exceed the int data type's maximum size. However, this data type will cause an error in SQABasic language if the recordset returned from a table contains a column of type BigInt.
SQABasic supports the following data types: String, Integer, Long, variant, object, Single, Double, Currency, and User-Defined.
SQABasic does not support the BigInt data type. This is an SQABasic limitation.
Resolving The Problem
Use SQL Server to assign the data type to the column as a "Float". From the point of view of SQL Server, it will be the same as a 64-bit BigInt value.
Historical Number
123692351
Was this topic helpful?
Document Information
More support for:
Rational Robot
Software version:
2002.05.20, 2003.06.00, 2003.06.10, 2003.06.12, 2003.06.13, 2003.06.14, 2003.06.15, 2003.06.16, 7.0, 7.0.0.1, 7.0.0.2, 7.0.1, 7.0.0.4, 7.0.1.3, 7.0.2
Operating system(s):
Windows
Document number:
74273
Modified date:
16 June 2018
UID
swg21121296