SQLTable.Seek Method (Usual, Usual, Usual)

Search for a value based on a controlling search order.

Namespace: XSharp.VO.SDK
Assembly: XSharp.VOSQLClasses (in XSharp.VOSQLClasses.dll) Version: 2.19

Syntax

 VIRTUAL METHOD Seek(
	symColumn,
	uValue,
	lSoftSeek
) AS LOGIC CLIPPER

[ClipperCallingConventionAttribute(new string[] { ... })]
public virtual bool Seek(
	Usual symColumn = default,
	Usual uValue = default,
	Usual lSoftSeek = default
)

Request Example View Source

Parameters

symColumn (Optional): Type: Usual
The column that is to be searched for.
uValue (Optional): Type: Usual
The value that is to be searched for of a type compatible with symColumn.
lSoftSeek (Optional): Type: Usual
Indicates whether the '>=' operator is to used in the where clause (TRUE) or if the '=' operator is to be used (FALSE).

Return Value

Type: Logic
TRUE if successful; otherwise, FALSE. (whether this is because the server is incapable of searching, or because the value was not found).

Remarks

SQLTable:Seek() dynamically rebuilds the select statement using the values in the WHERE clause.

Reference

SQLTable Class

Seek Overload

XSharp.VO.SDK Namespace