2.0 KiB

Raw Permalink Blame History

BOM Form Documentation

Overview

The BOM (Bill of Materials) form provides functionality for reading, displaying and managing BOM data from different sources.

Form Controls

Text Fields

txtAssembly - Assembly number input (8 characters - part number and revision)
txtBOM - Full path and filename of BOM file
txtGood - Status indicator field

Buttons

cmdReadBOM - Reads standard format BOM files
cmdReadAltimaBOM - Reads Altima format BOM files
cmdReadSolidBOM - Reads SolidWorks BOM files
cmdClearBOM - Clears existing BOM records
cmdShow - Displays loaded BOM data
cmdHide - Closes the form
cmdClose - Closes the form

Data Display

DataGrid1 - Displays BOM records with columns:
- WASM# (Assembly Number)
- WASMR (Revision)
- WCMP# (Component Number)
- WQTY (Quantity)
- WENTD (Entry Date)
lstStatus - Status and logging messages
lblStat - Status label

Data Connection

Adodc1 - ADO data control connected to EGBWP1A0 table via ODBCrms DSN

Key Functions

BOM Reading

Standard BOM format (cmdReadBOM_Click)
- Parses fixed width format files
- Handles Part and Sub-Assembly records
Altima BOM format (cmdReadAltimaBOM_Click)
- Parses CSV format files
- Skips header rows
SolidWorks BOM format (cmdReadSolidBOM_Click)
- Parses tab-delimited files
- Handles ItemNo, PartNo, Qty fields

BOM Management

Clear BOM (cmdClearBOM_Click)
- Removes existing records for an assembly
- Uses stored procedure for deletion
Show BOM (cmdShow_Click)
- Filters grid to show specific assembly/revision

Logging

Uses loglist() function to:
- Display status messages
- Maintain history in lstStatus
- Limit list to 600 entries

Data Format

Assembly numbers: 7 digits + 1 revision character
Quantities stored with 3 decimal places
Dates stored as YYYYMMDDHHNNSS

Error Handling

File existence checking
Error trapping for database operations
Status codes for operation results:
- 0: Success
- 1: Bad BOM format
- 2: File not found