Your full service technology partner! 
-Collapse +Expand
To/From Code
-Collapse +Expand Members-Only
Sign in to see member-only pages.
   ► KBTo/From GuidesDatabase  Print This     

Record Movement (Cross Ref > Database)

Record Movement

Languages Focus

Top, bottom, next, and previous.

ASP Classic:   MoveFirst, MoveLast, MoveNext

ASP uses MoveFirst, MoveLast, MoveNext, and MovePrevious to move a database cursor (a RecordSet).

Syntax Example:

The following snippet moves to the second to last record of a given RecordSet object:

Corel Paradox:   home, end, nextRecord

ObjectPAL uses home(), end(), nextRecord(), priorRecord() to move a database cursor (works with either a TCursor or UIObject).


These commands send a message to the object. Specifically, they send an action constant using the action command. The above snippet is equivalent to:


It is handy to  with familiar with action constants because not all action constants have an ObjectPAL equivalent comment.

Syntax Example:

The following snippet uses the active keyword to move to the second to last record of the table attached to the UIObject that currently has focus:


You can also use the self keyword to refer to the UIObject your code is attached to.

Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site:

©1995-2020 Prestwood IT Solutions.   [Security & Privacy]