Product Documentation

FairCom Java & .NET Stored Procedures

Previous Topic

Next Topic

SqlSpColumn

SqlSpColumn contains a column definition and value.

SqlSpColumn Interface Description

Public Read-Only Properties

Nullability IsNullable

Get the column nullability.


String Name

Get the column name.


int Precision

Get the column precision.


int Scale

Get the column scale.


SqlDataType SqlType

Get the column SQL TYPE.


Boolean IsNull

Return if the SQL value is null or not.

Public Read/Write Properties

Object Value

Get/Set the column value. The “object” must be of a type compatible with the column SQL TYPE.


Byte[] BinaryValue

Get/Set a Binary column value.


DateTime? DateValue

Get/Set a Date value.


Double? FloatValue

Get/Set a Float/Double (SQL) column value.


Int32? IntegerValue

Get/Set an Integer column value.


Decimal? MoneyValue

Get/Set a Money column value.


Decimal? NumericValue

Get/Set a Numeric column value.


Boolean? BitValue

Get/Set a Bit column value.


Int64? BigIntValue

Get/Set a BigInt column value.


Single? RealValue

Get/Set a Real column value.


Int16? SmallIntValue

Get/Set a SmallInt column value.


TimeSpan? TimeValue

Get/Set the column value.


DateTime? TimeStampValue

Get/Set a TimeStamp column value.


Int16? TinyIntValue

Get/Set a TinyInt column value.


String CharValue

Get/Set a [Var]Char column value.

TOCIndex