showcolumns
showcolumns
FIELDS

The showcolumns statement forces Panorama to display specified fields.

Parameters

This statement has one parameter:

fields – is a list of fields to be displayed. Each field name should be separated from the next by a comma. If a field name contains spaces or punctuation, or begins with any character except a letter or underscore, it should be surrounded by chevron (« ») characters.

Description

This statement tells Panorama to redisplay specified fields in the current record in every open window of the current database. Use this command after the noshow command when you have only modified certain fields in the current record. ShowFields does not turn the display back on. To do that you must use the endnoshow statement.

The example below would normally erase and re-display the current record three times. Adding the noshow and showfields statements suppresses the extra drawing. Even though three fields are modified, only the Balance field is erased and re-displayed once at the end of the procedure.

    noshow
        Date=today()
        Time=now()
        Balance=Credit-Debit
        runningtotal
        showcolumns Balance
    endnoshow

See Also

- addfield -- adds a new field to the current database (on the end).
- Adding New Fields -- adding one or more fields to a database.
- autoallfieldwidths -- automatically sets the width of all fields based on the data in each field.
- autofieldwidth -- automatically sets the width of the current field based on the data in it.
- Automatic Field Calculations -- performing formulas automatically when data is entered into a field.
- Automatic Field Code -- running a short program when data is entered into a field.
- automaticfieldchoices -- updates the current field's Choice list with actual data in the database.
- automaticfieldname( -- returns an available field name.
- cell -- enters a value into the currently active field (i.e. cell).
- checkdesignlock -- checks if field structure can be changed, if not, returns an error.
- commonfieldspopup -- pops up a list of common fields, and changes the current field specifications when a field is chosen from this menu.
- Construct Multiple Fields -- using a template to quickly add multiple fields to a database.
- constructfields -- creates one or more new fields based on a template.
- databaseconsoledump -- dumps the raw contents of the specified database to the console in comma delimited format.
- Date Patterns -- control how dates are displayed or converted to text.
- Dates -- working with dates.
- dbinfo( -- gets information about a database: what forms it contains, what fields, what flash art pictures, etc.
- deletefield -- deletes the current field from the database.
- Deleting Fields -- deleting fields from the database.
- Disable Editing of Individual Fields -- disable editing of inidividual database fields in the data sheet and/or forms.
- disablefieldediting -- disables editing for a specified list of database fields (all others are enabled).
- editfield -- begins editing of the specified field.
- editfieldname -- opens the data sheet window's field properties inspector and selects the field name.
- endnoshow -- resumes the output of text and graphics after it has been disabled with the noshow statement.
- endshowlater -- resumes the immediate display of text and graphics after it has been deferred with the showlater statement.
- Field Blueprint Dialog -- examining and modifying the raw specification of a field.
- Field Properties -- available field attributes.
- Field Properties Panel -- examining and modifying field attributes.
- Field Width -- adjusting the width of a field in the data sheet.
- fieldalignment( -- returns the alignment of a database field.
- fieldformula( -- returns the formula associated with a database field.
- fieldname -- changes the name of the current field.
- fieldnumber( -- returns the number of a database field (starting with 1).
- fieldpattern( -- returns the output pattern associated with a database field.
- Fields -- introduction to database fields.
- fieldtype -- changes the data type of the current field.
- fieldtypes -- returns a carriage return delimited array with list of fields and field data types.
- fieldtypes( -- returns a carriage return delimited array with a list of the fields and field data types.
- fieldwidth( -- returns the width (in the data sheet) of a database field.
- findreplacedialog -- opens the Find & Replace dialog.
- firstcolumn -- moves to the first column in the data sheet (leftmost column).
- fontcharacters( -- returns a string (text) containing all of the characters supported by the specified font.
- fontinfo( -- returns a dictionary with information about a specified font.
- getfieldproperties( -- returns a dictionary containing all of the properties of the specified field. (See the setfieldproperties statement if you want to change one or more field properties.)
- hiddenfields( -- returns a list of hidden fields in the curent data sheet window
- hide -- temporarily disables the output of text and graphics.
- hidecurrentfield -- hides the current field in the data sheet.
- hidefieldsbetween -- shows all fields except those in between specified numbers.
- hidelineitemfields -- hides all line item fields.
- hidethesefields -- hides specific fields in the data sheet, making all others visible.
- Hiding and Showing Fields -- temporarily hiding fields in the data sheet.
- info("datatype") -- returns the data type of the current field.
- info("disabledfields") -- returns a list of disabled fields in the current database (fields that cannot be edited).
- info("enabledfields") -- returns a list of enabled fields in the current database (fields that can be edited).
- info("noshow") -- returns true if noshow is currently turned on, false if it is not.
- insertfield -- inserts a new field into the database in front of the current field.
- lastcolumn -- move to the last column in the data sheet (rightmost column).
- Limiting the Maximum Number of Data Sheet Columns -- adjusting the maximum number of columns displayed in data sheet windows.
- Line Item Fields -- are used for repeating items within a record
- measuretext( -- returns the size of a string of text in a particular font and size.
- mergefieldsdialog -- opens the standard *Merge Fields* dialog.
- Merging Adjacent Fields -- merging two fields into one.
- movefieldbefore -- moves the current field to a new position.
- newdatabasewithfields -- creates a new database with one or more fields.
- newdatabasewithtemplate -- creates a new database with a template.
- noshow -- temporarily disables the output of text and graphics.
- Numeric Data -- numeric data (fixed and floating point).
- Numeric Patterns -- control how a number is displayed or converted to text.
- Rearranging Field Order -- rearranging the order of fields in the data sheet.
- reorderfieldsdialog -- opens the Reorder Fields dialog.
- richtextdata( -- adjusts text so that it will display properly in rich text even if it contains a < character.
- richtextdisplay( -- works with Text Display objects to display text with multiple styles, fonts, colors and alignments.
- serverdatabaseconsoledump -- dumps the raw contents of the specified database on the server to the console in comma delimited format.
- setbannericon -- sets the icon on the right side of the toolbar banner.
- setbannermessage -- sets the text in the toolbar banner to an arbitrary message.
- setbannerprogressbar -- displays progress in the toolbar banner.
- setfieldnames -- changes the names of all database fields at once.
- setfieldproperties -- modifies one or more properties (name, data type, formula, etc.) of the current field.
- show -- resumes the output of text and graphics after it has been disabled and then forces Panorama to redisplay all windows in the current database.
- showallfields -- makes every field in the data sheet visible.
- showfields -- forces Panorama to display specified fields.
- showfieldsbetween -- hides all fields except those in between specified numbers.
- showhidefieldsdialog -- opens the standard Show/Hide Fields dialog (in the Fields menu).
- showlater -- defers the display of text and graphics until the procedure is finished.
- showline -- forces Panorama to redisplay the current record in all windows in the current database.
- showother -- forces Panorama to update some data on the screen.
- showpage -- forces Panorama to redisplay all windows in the current database.
- showrecordcounter -- forces Panorama to redisplay the record counter in all windows in the current database.
- showthesefields -- makes specific fields in the data sheet visible, hiding all others.
- showvariables -- forces Panorama to update the display of one or more variables on every form in the active database.
- Smart Dates -- keyboard entry of dates.
- splitfielddialog -- opens the standard *Split Field* dialog.
- Splitting a Field -- splitting a field into two fields.
- textdisplay( -- works with Text Display Objects to control the color and style of text on the fly.
- tokenname( -- returns the name of a field or variable (instead of the value contained in the field or variables).
- visiblefieldnumbers( -- returns a data array of visible fields (by number) in the data sheet.
- visiblefields( -- returns a list of visible fields in the data sheet.

History

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