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


History

VersionStatusNotes
10.0No ChangeCarried over from Panorama 6.0.