DbServer Methods (Typed)

DbServer.Append Method

DbServer.AppendDB Method (Typed)

DbServer.AppendDelimited Method (Typed)

DbServer.AppendSDF Method (Typed)

DbServer.Average Method (Typed)

DbServer.BLOBDirectExport Method

DbServer.BLOBDirectGet Method (Typed)

DbServer.BLOBDirectImport Method

DbServer.BLOBDirectPut Method (Typed)

DbServer.BLOBExport Method

DbServer.BLOBGet Method (Typed)

DbServer.BLOBImport Method (Typed)

DbServer.BLOBRootGet Method (Typed)

DbServer.BLOBRootLock Method (Typed)

DbServer.BLOBRootPut Method (Typed)

DbServer.BLOBRootUnlock Method (Typed)

DbServer.ClearFilter Method (Typed)

DbServer.ClearIndex Method (Typed)

DbServer.ClearLocate Method (Typed)

DbServer.ClearOrderScope Method (Typed)

DbServer.ClearRelation Method (Typed)

DbServer.ClearScope Method (Typed)

DbServer.Close Method (Typed)

DbServer.Commit Method (Typed)

DbServer.ConstructUniqueAlias Method (Typed)

DbServer.Continue Method (Typed)

DbServer.CopyDB Method (Typed)

DbServer.CopyDelimited Method (Typed)

DbServer.CopySDF Method (Typed)

DbServer.CopyStructure Method

DbServer.Count Method (Typed)

DbServer.CreateIndex Method (Typed)

DbServer.CreateOrder Method (Typed)

DbServer.DataField Method (Typed)

DbServer.Delete Method

DbServer.DeleteAll Method (Typed)

DbServer.DeleteOrder Method (Typed)

DbServer.Error Method (Typed)

DbServer.Eval Method (Typed)

DbServer.FieldGet Method (Typed)

DbServer.FieldGetBytes Method (Typed)

DbServer.FieldGetFormatted Method (Typed)

DbServer.FieldHyperLabel Method (Typed)

DbServer.FieldInfo Method (Typed)

DbServer.FieldName Method (Typed)

DbServer.FieldPos Method (Typed)

DbServer.FieldPut Method (Typed)

DbServer.FieldPutBytes Method (Typed)

DbServer.FieldSpec Method (Typed)

DbServer.FieldStatus Method (Typed)

DbServer.FieldSym Method (Typed)

DbServer.FieldValidate Method (Typed)

DbServer.FLock Method (Typed)

DbServer.GetArray Method (Typed)

DbServer.GetLocate Method (Typed)

DbServer.GetLookupTable Method (Typed)

DbServer.GoBottom Method (Typed)

DbServer.GoTo Method (Typed)

DbServer.GoTop Method (Typed)

DbServer.IndexKey Method (Typed)

DbServer.IndexOrd Method (Typed)

DbServer.Info Method (Typed)

DbServer.Join Method (Typed)

DbServer.Locate Method (Typed)

DbServer.LockCurrentRecord Method (Typed)

DbServer.LockSelection Method (Typed)

DbServer.NoIVarGet Method (Typed)

DbServer.NoIVarPut Method (Typed)

DbServer.Notify Method (Typed)

DbServer.OrderDescend Method

DbServer.OrderInfo Method (Typed)

DbServer.OrderIsUnique Method

DbServer.OrderKeyAdd Method

DbServer.OrderKeyCount Method

DbServer.OrderKeyDel Method

DbServer.OrderKeyGoTo Method (Typed)

DbServer.OrderKeyNo Method

DbServer.OrderScope Method (Typed)

DbServer.OrderSkipUnique Method (Typed)

DbServer.Pack Method (Typed)

DbServer.RddInfo Method (Typed)

DbServer.Recall Method (Typed)

DbServer.RecallAll Method (Typed)

DbServer.RecordInfo Method (Typed)

DbServer.Refresh Method (Typed)

DbServer.Reindex Method (Typed)

DbServer.Relation Method (Typed)

DbServer.Replace Method (Typed)

DbServer.ResetNotification Method (Typed)

DbServer.RLock Method (Typed)

DbServer.RLockVerify Method (Typed)

DbServer.Seek Method

DbServer.Select Method (Typed)

DbServer.SetDataField Method (Typed)

DbServer.SetFilter Method (Typed)

DbServer.SetIndex Method

DbServer.SetOrder Method

DbServer.SetOrderCondition Method (Typed)

DbServer.SetRelation Method (Typed)

DbServer.SetSelectiveRelation Method (Typed)

DbServer.Skip Method (Typed)

DbServer.Sort Method

DbServer.Sum Method (Typed)

DbServer.SuspendNotification Method (Typed)

DbServer.Total Method (Typed)

DbServer.UnLock Method (Typed)

DbServer.Update Method

DbServer.Zap Method (Typed)

DbServer.OrderKeyGoTo Method (Typed)

Move to a record specified by its logical record number in the controlling order.

Namespace: XSharp.VO.SDK
Assembly: XSharp.VORDDClasses (in XSharp.VORDDClasses.dll) Version: 2.21

Syntax

Copy

 VIRTUAL METHOD OrderKeyGoTo(
	nKeyNo AS LONG
) AS LOGIC

public virtual bool OrderKeyGoTo(
	int nKeyNo
)

Request Example View Source

Parameters

nKeyNo: Type: Long
The logical record number. If the value specified does not satisfy the scope or for condition for the order, the record pointer is positioned at the end-of-file.

Return Value

Type: Logic
TRUE if successful; otherwise, FALSE.

Remarks

DBServer:OrderKeyGoTo() is the complement to DBServer:OrderKeyNo(). DBServer:OrderKeyNo() returns the logical record number (i.e., its position in the controlling order) of the current record, and DBServer:OrderKeyGoTo() moves the record pointer to the specified logical record. DBServer:OrderKeyGoTo() sends a NotifyIntentToMove message before the operation. It also sends a NotifyRecordChange message upon successful completion. Tip: This method can be useful when displaying scroll bars. If the user clicks on a certain position on the scroll bar, you can move to the corresponding record by calling DBServer:OrderKeyGoTo().

Examples

This example shows the difference between physical and logical record number:

Copy

1oDBCust := Customer{}
2oDBCust:SetIndex("first")     // Make records in first name order
3oDBCust:OrderKeyGoTo(100)         // Go to the 100th logical record
4? oDBCust:RECNO            // Returns the physical record number
5? oDBCust:OrderKeyNo()        // Returns 100, the logical record no

Reference

DbServer Class

XSharp.VO.SDK Namespace