Click or drag to resize

SQLSelect.SetPrimaryKey Method (Typed)

X#
Specify a column to be used as a unique index in searched updates or deletes that require a key (i.e., SQLSelect:ScrollUpdateType = SQL_SC_UPD_KEY).

Namespace:  XSharp.VO.SDK
Assembly:  XSharp.VOSQLClasses (in XSharp.VOSQLClasses.dll) Version: 2.21
Syntax
 VIRTUAL METHOD SetPrimaryKey(
	uFieldPos
) AS LOGIC CLIPPER
Request Example View Source

Parameters

uFieldPos (Optional)
Type: Usual
The name, number, or symbol representing the desired column.

Return Value

Type: Logic
TRUE if successful; otherwise, FALSE.
Remarks
If SQLSelect:SetPrimaryKey() is passed a zero as an argument, all assigned columns are cleared. You can also find the unique index columns by using the SQLListSpecialColumns class.
See Also