Xplore Options

•

'Click on Header to Re-Order' (default in ON) is required if the developer intends to offer the end-user the ability to click on any list box column header to re-sort the data. This is a Windows-95 Explorer type functionality where the column header will appear to depress just like a real button. If switched ON, then the default is that each column will be sorted on the file field that it is displaying. If switched OFF, the end-user will not be able to re-sort by any column; however, they will still be able to re-format the columns of the browse box.

•

'Visual Clue for Re-Order Sequence' defines how the developer will indicate to the end-user which column is currently ordering the data. The '>Header' puts an indicator in the column header to signify ascending (>) or descending (<). The 'Text Bar' will put a text string (identified by the next dialog control) in the window title bar. 'Underline' will underline the data in that column and 'Nothing' will offer no indication to the end-user.

•	'Text for Sorted Order' allows the developer to specify text to be merged with the column identifier which will get placed window title bar. The field header will get inserted between the '''' markers.

•	'Default Column Locator' allows the developer to define which locator will be the default for each column. Any particular column can be over-ridden later with options under the Columns TAB.

•	'Message(..) issued...' specifies whether the end-user will be presented with a message box informing them that the option does not work on a particular column. If switched OFF, then clicking on a non-sorting column-header will just do nothing. The column header button will not appear to depress.

•	'Multiple Keys on TABs' specifies whether there are multiple TAB selections on the window (as generated by the standard Clarion Wizard) with a new key for each TAB.

•	'Multiple Format Strings' allows the developer to specify whether the end-user can maintain a different format string for each TAB. The different format strings are defined/modified/maintained at runtime.

•	'NewSelection Tab/Radio' needs to specify the window control (TAB or RADIO) that will invoke each new format string. All of the format strings are saved between sessions.

•	'Seperate TABs for each Column (Wizard Sheet)' will allows the developer to specify a different TAB (and hence, different controls) for each column. The new TAB will be invoked when the end-user clicks on the column header to invoke its sort order.

•	'Default TAB' requires the developer to specify which TAB is the default for each column. Individual columns are then overridden using the dialog on the template Columns TAB.

•	N.B. If you have column in the Browse Box displaying a local variable, AND, you're allowing the end-user to sort on that column, then you MUST make an entry for this column which tells the View engine which view field to use for ordering.

•	'Initial Sort Sequence' offers the developer the ability to specify which sequence will be shown initially when the browse is initiated. If you have multiple TABs with multiple Keys, then take note that the 'Previous Session' can cause some initial 'flashing'.

•	'Column Field Assignments' allows the developer to alter the defaults for each column. This need NOT be done for every column - only those that you need to alter.

•	'Column Field' is the name of the field being displayed. In the case of a column showing a local variable, you MUST specify the local variable here, not the view field that is priming it.

•

'Allow Sort on this Column' (Defaulted to ON) allows the developer to switch OFF the sorting capability for any individual column. NOTE: It is also possible to switch the capability on/off at runtime on an individual column basis. This may be done based on the security level of the user for instance.

•	'TAB Selection for Column' will only be active if the developer has specified 'Seperate TABs for each Column(Wizard Sheet)' on the pervious dialog. This allows the developer to select a different TAB for this particular column.

•	'Locator' (Defaulted to “Step”) allows the developer to specify a different locator type for this column when the list box is sorted on this column. The new 'Filtered' locator works well on string fields.

•

'Sort Field Elements' allows the developer to define as many fields as are desired for presenting the order of the data. The developer may also specify ascending or descending sort orders. (This is just like building a dynamic key.) If the column is displaying a local variable and sort is allowed on this column, then the developer MUST specify a view field here for the view engine to sort on.

•	'Create Report Totals on this Column' gives the developer the option of creating totals on this column at the end of the built-in view report. Usually this should only be specified on columns showing numeric data.

•

'Allow Graph on this Column' specifies whether the end-user can create a bar graph of the column data. e.g. if the column is displaying 'Country', then it might be useful to create a bar graph of which countries the current filtered view has selected. It would not be logical to create a graph of a field such as an 'Address' column.

•	'Graph Details' offers the developer some choices on how to graph some common types of data: Date; Time; Numeric; String. NOTE: An EMBED point has been provided to clone/modify the existing code if complex graphing capability is required.

•	‘Additional Default Sort Order Fields for Columns' allows the developer to define any number of fields which will automatically be appended to each column sort order. This provides a quick method of making each record unique in a sort order display.

•	'Apply Additional Sort Fields to ALL Columns' - if checked ON then it will apply the fields to all columns. If checked OFF, then the additional sort order fields will only be applied to columns which do not have any fields specified in the 'Sort Field Elements' of the 'Column Field Assignments'.

'Xplore Options' offers the developer a means to quickly set on or off ALL of the check boxes, and to reset the switches to those specified in the Global extension template. Otherwise, each switch may be independently set as required for the procedure. The option check-boxes allow the developer to decide which options to give the end-user via the browse box right-click capability at run time.

NOTE: The end-user will be able to (1) shift columns right and left by dragging the column header; (2) be able to reset the browse box back to its default format setting and, (3) be able to create output of the browse via a page/view report or a graph, even with all options switched OFF.