Mimer SQL Data Provider help
GetValue Method




Mimer.Data.Client Namespace > MimerDataReader Class : GetValue Method
The zero-based column ordinal position.
Gets the column in its native format.
Syntax
'Declaration
 
Public Overrides NotOverridable Function GetValue( _
   ByVal i As Integer _
) As Object
public override object GetValue( 
   int i
)
public function GetValue( 
    i: Integer
): TObject; override; 
public override function GetValue( 
   i : int
) : Object;
public: Object* GetValue( 
   int i
) override 

Parameters

i
The zero-based column ordinal position.

Return Value

The native format value.
Exceptions
ExceptionDescription
The MimerDataReader is not positioned on a row.
The column ordinal is outside the valid range.
Remarks
Currently the Mimer ADO.NET data provider returns values as standard .NET data types. Please note that this may change in the future. The result data type is chosen to always be able to hold the output value.
SQL Data Type Returned .NET data type
DECIMAL, NUMERIC Precision: 1 <= System.Decimal <= 28 < System.String <= 45
BIGINT System.Int64
INTEGER System.Int32
INT(precision) precision: 1 <= System.Int16 < 5 <= System.Int32 < 10 <= System.Int64 < 19 <= System.Decimal < 29 <= System.String <= 45
FLOAT(precision) System.String (as Mimer the FLOAT supports exponents up to 999 while the maximum for System.Double is 308)
DOUBLE PRECISION System.Double
REAL System.Single
CHAR, VARCHAR, NCHAR, NVARCHAR, CLOB, NCLOB System.String
DATE, TIME, TIMESTAMP System.DateTime
INTERVAL YEAR, INTERVAL MONTH System.Int32
INTERVAL YEAR TO MONTH System.String
INTERVAL DAY, INTERVAL HOUR, INTERVAL MINUTE, INTERVAL DAY TO HOUR, INTERVAL DAY TO MINUTE, INTERVAL DAY TO SECOND, INTERVAL HOUR TO MINUTE, INTERVAL HOUR TO SECOND, INTERVAL MINUTE TO SECOND System.TimeSpan
INTERVAL SECOND(precision) precision: 1 <= System.TimeSpan <= 11 < System.String <= 12
ODBC.GUID System.Guid
BINARY, VARBINARY, BLOB System.Byte []
Requirements

.NET Framework
Version 2.0 or later

See Also

Reference

MimerDataReader Class
MimerDataReader Members