Grid - Attached File Mode

 

The grid contains 8 columns, of which column 3 and column 5 can be modified. The data in the remaining columns is either obtained from a file in the database, or calculated based on the information entered into columns 3 or 5.

 

(Grid) - Adding a Line Item:

To add a line item press the Insert key when the grid has focus, or select Edit -> Add Line Item from the Menu Bar. Pressing F8 when in column 3 will display a look-up list containing item IDs and descriptions. When an item is added, the row color is set at black text with a green

background.

 

(Grid) - Columns:

Order #, Line #, Item ID, Quantity, Price, and Weight are obtained from the O_LINE file. The Item Description is obtained from the ITEM file. The value in the Extension column is calculated based on the values in the Item ID and Price columns. When a change is made to an Item ID or Quantity, the values in the Weight and Extension columns are re-calculated based on those changed values.

 

(Grid) - Deleting a Line Item:

To delete a line item, move the highlighted cell to the row on the grid that contains the line item to be deleted, press the Delete key, or select Edit -> Delete Line Item from the Menu Bar. The line item to be deleted is identified by a change of row color to black text with a light gray background. When changes are saved, the line item is then actually deleted from the O_LINE

file.

 

(Grid) - EditingaCell:

Left double clicking, entering a number, or pressing the enter key on column 3 or column 5 will place the grid cell in the edit mode. When the edit mode is Non-Sequential, after a cell is selected for edit and the edit is complete, the highlighted cell remains on the cell that was edited. In the Sequential Edit mode, after the edit is complete, the cell being edited automatically moves to the next cell in the grid from column 3 to column 5 and then to column 3 in the next higher row in the grid and so on. To change the edit mode, from the Menu Bar select Edit -> Edit Mode and then the desired edit mode. When a cell has been modified, the row is identified with a change of row color to black text with a cyan background.

 

(Grid) - Look-Up List:

When the grid focus (highlighted cell) is on a cell in the Item ID or Description column, pressing F8 or right clicking on the cell will display a listedit control that can be used to select an Item ID from a list of selections.

 

(Grid) - Restoring a Line Item:

To restore a line item, move the highlighted cell to the row that contains the line item to be restored. If the selected line item was added, it is removed from the grid, deleted (marked) line items are changed to the normal row color of black text and a white background. Changed line items are restored to original values and row colors.

 

(Grid) - Scroll Bars:

The right side of the grid control contains two vertical scrollbars. The lower scrollbar, which has no thumb, moves the grid display one page up or one page down each time it is left clicked, similar to pressing the keyboard page up / page down keys. The upper scrollbar, which contains a thumb, moves the display one line up or one line down when left clicking on the arrow portion of the control. In Attached File mode 1 and 3, moving the thumb of the upper scrollbar will cause a move to a position in the attached file proportionally to the location of the thumb within the scrollbar. As an example, if the thumb is at its' top most position, the grid display contains the record data corresponding to the beginning keys in the file. At thumb mid position, the record data displayed corresponds to the keys in the middle of the file, and so on. In Attached File mode 2, moving the thumb has the same affect as left clicking on the scrollbar up or down arrow. Prototype Topic: Attached File, provides additional information on this subject.