Prestwood: Record Movement (Cross Ref

Record Movement (Cross Ref > Database)

Record Movement

Top, bottom, next, and previous.

ASP Classic: MoveFirst, MoveLast, MoveNext

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

objRecordSet.MoveNext

Syntax Example:

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

objRecordSet.MoveLast

objRecordSet.MovePrevious

ObjectPAL: home, end, nextRecord

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

TCursor.nextRecord()

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

TCursor.action(DataNextRecord)

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:

active.end()

active.priorRecord()

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

An ObjectPAL Primer: Part 3 1 certification question.