SQLListSpecialColumns Constructor (Typed) | |
Construct an SQLListSpecialColumns object.
Namespace:
XSharp.VO.SDK
Assembly:
XSharp.VOSQLClasses (in XSharp.VOSQLClasses.dll) Version: 2.19
Syntax CONSTRUCTOR(
nColType,
cQualifier,
cOwner,
cTableName,
nScope,
nNullable,
oSQLConnection
) CLIPPER
[ClipperCallingConventionAttribute(new string[] { ... })]
public SQLListSpecialColumns(
Usual nColType = default,
Usual cQualifier = default,
Usual cOwner = default,
Usual cTableName = default,
Usual nScope = default,
Usual nNullable = default,
Usual oSQLConnection = default
)
Request Example
View SourceParameters
- 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
Constant | Description |
---|
SQL_BEST_ROWID | Returns 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_ROWVER | Returns 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
Constant | Description |
---|
SQL_SCOPE_CURROW | The 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_SESSION | The row ID is guaranteed to be valid for the duration of the session (across transaction boundaries). |
SQL_SCOPE_TRANSACTION | The row ID is guaranteed to be valid for the duration of the current transaction. |
kNullable possible values
Constant | Description |
---|
SQL_NO_NULLS | Exclude special columns that can have NULL values. |
SQL_NULLABLE | Return special columns, even if they can have NULL values. |
Level 1
See Also