Learning
Documentation
Community
Open Exchange
Global Masters
Home / Class Reference / ENSLIB namespace / %SQL.StatementColumn
Private  Storage   

%SQL.StatementColumn


serial class %SQL.StatementColumn extends
%SerialObject

%SQL.StatementColumn - contains the metadata for a statement column whose column type is SQLRESULTCOL.

Inventory


Parameters Properties Methods Queries Indices ForeignKeys Triggers
24 5


Summary


Properties
ODBCType clientType colName isAliased
isAutoIncrement isCaseSensitive isCurrency isExpression
isHidden isIdentity isKeyColumn isNullable
isReadOnly isRowId isRowVersion isUnique
label precision property qualifier
scale schemaName tableName typeClass

Methods
%AddToSaveSet %AddToSyncSet %ClassIsLatestVersion %ClassName
%ConstructClone %Delete %DeleteId %DispatchClassMethod
%DispatchGetModified %DispatchGetProperty %DispatchMethod %DispatchSetModified
%DispatchSetMultidimProperty %DispatchSetProperty %Extends %GetParameter
%GetSwizzleObject %IsA %IsModified %IsNull
%New %NormalizeObject %ObjectIsNull %ObjectModified
%OnBeforeAddToSync %OnDetermineClass %Open %OpenId
%OriginalNamespace %PackageName %RemoveFromSaveSet %ResolveConcurrencyConflict
%SerializeObject %SetModified %SyncObjectIn %SyncTransport
%ToDynamicObject %ToJSONValue %ValidateObject IsNumeric
LogicalToOdbc OdbcToLogical


Properties


• property ODBCType as %Integer;
The column ODBC type integer:
• property clientType as %Integer;
Returns the type of column n in the result set where type is an integer associated with the client datatype. If the type cannot be determined, 0 (zero) is returned.
1BINARY
2DATE
3DOUBLE
4HANDLE
5INTEGER
6LIST
7LONGVARCHAR
8TIME
9TIMESTAMP
10VARCHAR
11STATUS
12BINARYSTREAM
13CHARACTERSTREAM
14NUMERIC
15CURRENCY
16BOOLEAN
17OID
18BIGINT
19FDATE
20FTIMESTAMP
• property colName as %String(MAXLEN=255);
The column name.
• property isAliased as %Boolean;
• property isAutoIncrement as %Boolean;
• property isCaseSensitive as %Boolean;
• property isCurrency as %Boolean;
• property isExpression as %Boolean;
• property isHidden as %Boolean;
• property isIdentity as %Boolean;
• property isKeyColumn as %Boolean;
• property isNullable as %Boolean;
isNullable is TRUE (1) if the column value can be NULL.
• property isReadOnly as %Boolean;
• property isRowId as %Boolean;
• property isRowVersion as %Boolean;
• property isUnique as %Boolean;
• property label as %String(MAXLEN=255);
• property precision as %Integer;
Precision
• property property as %Dictionary.CompiledProperty;
If this column corresponds to a property from the class that projected the tableName table. This property is NULL if the column cannot be linked to a property.
• property qualifier as %String;
• property scale as %Integer;
Scale
• property schemaName as %String;
The schema qualifier of tableName.
• property tableName as %String;
The table where this column originates.
• property typeClass as %Dictionary.CompiledClass;
The objects type class

Methods


• method %ToDynamicObject(target As %DynamicObject = "", ignoreUnknown=0) as %Library.DynamicObject
Default mechanism for mapping the fields of a registered object to the key-value pairs of a dynamic entity. This method exists only to provide the user with the ability to override the default composition of a dynamic object from a registered object.
• method %ToJSONValue(Output outstr="") as %String
Default behavior of the JSON generation facility. Map the current registered object into a dynamic one via $toAbstractObject() and output the JSON representation of the abstract object. Subclasses may wish to override this routine to perform post processing on the abstract object prior to JSON generation, or dispense with the abstract layer entirely in favor of direct, local JSON output
• method IsNumeric() as %Boolean