Ga naar inhoud

Form InventoryDetails

  • Unit name: Forms.Details.Inventory
  • Form name: TInventoryDetailsForm
  • Old form name: form123 (unit123)

Synopsis

Form to display inventory detail

Functionalities

  1. 2 columns: Start/End
  2. For each column the following comboboxes
  3. Place (filled with data from LocationPlaces view)
  4. Row (filled with data from LocationRows view)
  5. Level (filled with data from LocationLevels view)
  6. Properties to access all values.
  7. Button for OK action.
  8. Button for Cancel action.

Actions

OK

  1. Active only if all values are non-empty.
  2. When executed, sets

Cancel

  1. Always active.
  2. When executed, sets form modalresult to mrCancel.

Tables/Views

LocationPlaces 

SELECT RIGHT(LEFT(LOCATION,7),2) FROM LOCATION WHERE (NotForInventory<>'Y')
LocationRows 
SELECT RIGHT(LEFT(LOCATION,4),2) FROM LOCATION WHERE (NotForInventory<>'Y')
LocationLevels 
SELECT RIGHT(LOCATION,1) FROM LOCATION WHERE (NotForInventory<>'Y')

Needed Service Calls

None.

Reports

None.