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 property	HiRDBType property
AnsiString	VarChar
AnsiStringFixedLength	Char
Binary	Binary
Boolean	[NotSupportedException exception]
Byte	SmallInt
Currency	[NotSupportedException exception]
Date	Date
DateTime	TimeStamp
Decimal	Decimal
Double	Float
Guid	[NotSupportedException exception]
Int16	SmallInt
Int32	Integer
Int64	Decimal
Object	Binary
SByte	SmallInt
Single	SmallFlt
String	MvarChar
StringFixedLength	Mchar
Time	Time
UInt16	Integer
UInt32	Decimal
UInt64	Decimal
VarNumeric	[NotSupportedException exception]

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

HiRDBType property	DbType property
Binary	Object
Blob	Object
Char	AnsiStringFixedLength
Date	Date
Decimal	Decimal
Float	Double
Integer	Int32
IntervalYearToDay	String
IntervalHourToSecond	String
MChar	StringFixedLength
MVarChar	String
NChar	StringFixedLength
NVarChar	String
SmallFlt	Single
SmallInt	Int16
Time	Time
TimeStamp	DateTime
VarChar	AnsiString