right statement

right

The right statement moves the cursor to the next field in the active window.

Parameters

No parameters.

Description

This statement moves the cursor to the next field in the active window. If the current window is the data sheet the cursor will appear to move to the right one column. If the cursor is already on the last visible column this statement will do nothing. You can use this statement in conjunction with the info(“fieldname”) or info(“stopped”) functions to test to see if you are on the last visible record in the window.

This example converts all text fields in the current database to all upper case. It starts with the leftmost field and moves to the right column by column. (Note: The «» symbols, as used in the upper( function, always refers to the current field.)

field (array( dbinfo("fields",""),1,cr()))
loop
    if info("datatype")=0
        formulafill upper(«»)
    endif
    right
until info("stopped")

Here is a similar example that sets up the field names in a newly imported database. Many programs export field names as the first line of a text file. This procedure takes those field names and copies them into Panorama’s field names, then deletes the line containing the field names.

field "A"
loop
    fieldname «»
    right
    until info("stopped")
deleterecord

See Also

downrecord -- moves the cursor down one visible record.
field -- tells Panorama to move to the specified field for the current record.
firstrecord -- makes the first visible (selected) record in the database the active record.
info("bof") -- returns true if the active record is currently on the first visible (selected) record.
info("eof") -- returns true if the active record is currently the last visible (selected) record.
lastrecord -- makes the last visible (selected) record in the database the active record.
left -- makes the previous field active in the active window.
uprecord -- moves the cursor up one visible record.

History

Version	Status	Notes
10.0	No Change	Carried over from Panorama 6.0.