Numeric value out of range when activating TSQLQuery component related to a SQL Server table having a field "uniqueidentifier"
Original Reporter info from Mantis: hum802
-
Reporter name: Humberto Sa
Original Reporter info from Mantis: hum802
- Reporter name: Humberto Sa
Description:
TSQLQuery component cannot handle sql server datatype uniqueidentifier. When setting Active property to true, we get
Could not get field data for field "ExternalSourceGUID" (index 3). ODBC error details:
LastReturnCode: SQL_ERROR; Record 1: SqlState: 22003; NativeError: 0; Message: Numeric value out of range;
The fields are added fine. If i look at the LFM file I see below for the definition of the field:
object TQueryExternalSourceGUID: TGuidField
FieldKind = fkData
FieldName = 'ExternalSourceGUID'
Index = 2
LookupCache = False
ProviderFlags = [pfInUpdate, pfInWhere]
ReadOnly = False
Required = False
Size = 38
end
Steps to reproduce:
create a table with at least 1 field of datatype uniqueidentifier. From TSQLQuery component, try to set Active property to true.
Mantis conversion info:
- Mantis ID: 38275
- OS: windows
- OS Build: 10.0.17763
- Platform: 64bit
- Version: 3.2.0