Click or drag to resize

SQLListSpecialColumns Constructor (Typed)

X#
Construct an SQLListSpecialColumns object.

Namespace:  XSharp.VO.SDK
Assembly:  XSharp.VOSQLClasses (in XSharp.VOSQLClasses.dll) Version: 2.21
Syntax
 CONSTRUCTOR(
	nColType,
	cQualifier,
	cOwner,
	cTableName,
	nScope,
	nNullable,
	oSQLConnection
) CLIPPER
Request Example View Source

Parameters

nColType (Optional)
Type: Usual
A search string or one of the following constants representing the type of column to return:
cQualifier (Optional)
Type: Usual
The search string or name of the table qualifier.
cOwner (Optional)
Type: Usual
The search string or name of the table owner.
cTableName (Optional)
Type: Usual
The search string or name of the table.
nScope (Optional)
Type: Usual
One of the following constants representing the minimum required scope of the current row ID (the returned row ID can be of greater scope.):
nNullable (Optional)
Type: Usual
One of the following constants representing whether to return special columns that can have a NULL value:
oSQLConnection (Optional)
Type: Usual
The SQL connection indicating where the table can be found. If not specified, the current default connection is used, if any; if none is defined, the system asks the end user to log on to a database.
Remarks
kColumnType possible values
ConstantDescription
SQL_BEST_ROWIDReturns the optimal column or set of columns that, by retrieving values from the column(s), allows any row in the specified tables to be uniquely identified.
SQL_ROWVERReturns the column(s) in the specified table, if any, that are automatically updated by the data source when any value in the row is updated by any transaction.
kScope possible values
ConstantDescription
SQL_SCOPE_CURROWThe row ID is guaranteed to be valid only while positioned on that row. A later reselect using row ID may not return a row if the row was updated or deleted by another transaction.
SQL_SCOPE_SESSIONThe row ID is guaranteed to be valid for the duration of the session (across transaction boundaries).
SQL_SCOPE_TRANSACTIONThe row ID is guaranteed to be valid for the duration of the current transaction.
kNullable possible values
ConstantDescription
SQL_NO_NULLSExclude special columns that can have NULL values.
SQL_NULLABLEReturn special columns, even if they can have NULL values.
Level 1
See Also