The right statement moves the cursor to the next field in the active window.
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
|10.0||No Change||Carried over from Panorama 6.0.|