15.7.1 DbType and HiRDBType properties

When the DbType property of the HiRDBParameter class is set, the HiRDBType property of the same class is automatically set. When the HiRDBType property is set, the DbType property is automatically set. Table 15-3 lists the HiRDBType property values that are automatically set when the DbType property is set, and Table 15-4 lists the DbType property values that are automatically set when the HiRDBType property is set.

Table 15-3 HiRDBType property values that are automatically set when the DbType property is set

DbType propertyHiRDBType property
AnsiStringVarChar
AnsiStringFixedLengthChar
BinaryBinary
Boolean[NotSupportedException exception]
ByteSmallInt
Currency[NotSupportedException exception]
DateDate
DateTimeTimeStamp
DecimalDecimal
DoubleFloat
Guid[NotSupportedException exception]
Int16SmallInt
Int32Integer
Int64Decimal
ObjectBinary
SByteSmallInt
SingleSmallFlt
StringMvarChar
StringFixedLengthMchar
TimeTime
UInt16Integer
UInt32Decimal
UInt64Decimal
VarNumeric[NotSupportedException exception]

Table 15-4 DbType property values that are automatically set when the HiRDBType property is set

HiRDBType propertyDbType property
BinaryObject
BlobObject
CharAnsiStringFixedLength
DateDate
DecimalDecimal
FloatDouble
IntegerInt32
IntervalYearToDayString
IntervalHourToSecondString
MCharStringFixedLength
MVarCharString
NCharStringFixedLength
NVarCharString
SmallFltSingle
SmallIntInt16
TimeTime
TimeStampDateTime
VarCharAnsiString