Column Systems Ltd
all_pix_trans.gif (807 bytes)
Column Systems - HtBolts32.Net - High Temperature Bolts Database Management System - NEWS.

Welcome to HtBolts32.Net®, the Industry Standard in High Temperature Bolts Database Management. This power-packed version of HtBolts32.Net combines exciting features with the established functionality HtBolts32 (32-bit) and HtBolts (16-bit) users have come to rely on.

See HtBolts32.Net OVERVIEW, DOWNLOAD and SLIDESHOW.

Fixes for each Support Pack are prioritized and released on or about end of each yearly quarter. All support packs are full builds of HtBolts32.Net, thus it is not necessary to update incrementally. The most recent Support Pack in the below table is listed first.

HtBolts32.Net

- version 4.02.00.08 - Released Feb 2016.

This version provides new features and enhancements, including :
 
All Maintenance form(s) :-
Save NEW record or Update CURRENT record, checks If NO data entered on mandatory data field(s), then after warning message, move focus to missing data field(s).
 
Bolts Maintenance form :-
TreeView - Improved performance.
FIXED BUG, Bolts document(s), if amend 'Notes' field and Update CURRENT record, DO NOT display 'Sorry, there are DUPLICATE Codes in table BOLTDOCUMENTS'.
FIXED BUG, If no Bolt records exist, then NEW record button works correctly.
NEW feature - If Notes exist, then change TAB Notes (CustomEndColor) RGB colour to YELLOW (255, 255, 128) otherwise, change to Default (130, 169, 225).
BOLT record(s), Save NEW record or Update CURRENT record, checks If NO 'Unit', 'Location', 'Code', 'Design Factor', 'Material' or 'Basic Life Hours' entered, then after warning message, move focus to missing data field(s).
BOLT 'Tightening' record(s), Save NEW record or Update CURRENT record, checks If NO 'Operating Date', 'Tightening Method' or 'Update Retighten At Hours' entered, then after warning message, move focus to missing data field(s).
BOLT 'Nuts' record(s), Save NEW record or Update CURRENT record, checks If NO 'Nut Type' entered, then after warning message, move focus to missing data field.
BOLT 'Documents' record(s), Save NEW record or Update CURRENT record, checks If NO 'Document' or 'Notes' entered, then after warning message, move focus to missing data field(s).
BOLT 'History' record(s), Save NEW record or Update CURRENT record, checks If NO Material' or 'Last Updated' entered, then after warning message, move focus to missing data field(s).
 
Unit Details Maintenance form :-
FIXED BUG, Update CURRENT record, shows correct message(s).
 
Unit Maintenance form :-
FIXED BUG, Update CURRENT record, shows correct message(s).
 
Material Basic Life Hours Maintenance form :-
FIXED BUG, Update CURRENT record, shows correct message(s).

- version 4.02.00.07 - Released July 2015.

This version provides new features and enhancements, including :
 
System Parameters Maintenance form :-
NEW 'SystemParameter_MaterialsBasicLifeHoursPenaltyFactorControlFromDate' record. Used together with 'SystemParameter_MaterialsBasicLifeHoursPenaltyFactorControlYN' (set to 'Y' only). Used to calculate the Penalty Hours for the tightening operation from a specific date ( Format dd/mm/yyyy ).
NEW 'SystemParameter_MaterialsBasicLifeHoursPenaltyFactorControlDescription' record. Used together with 'SystemParameter_MaterialsBasicLifeHoursPenaltyFactorControlYN' (set to 'Y' only). Used to display 'Axial Temperature Gradient Factor' SHORT Description i.e. (Kg) or (Ka).
NEW 'SystemParameter_HelpPath' record. Used to locate help file folder and setup link to Help file ( HtBolts.chm ) i.e. 'Help' or 'C:\Program Files\HtBolts32.Net\Help' or '\\{ServerLocation}\HtBolts32.Net\Help'
NEW 'SystemParameter_MaintenanceContractValidToDate' (encrypted) record. Note! This is used to control if HtBolts32.Net Maintenance contract valid or not.
NEW feature - dialog Box to select and validate 'SystemParameter_HelpPath' help file folder value
NEW feature - dialog Box to select and validate 'SystemParameter_ReportsPath' report file(s) folder value
On closing form, if 'SystemParameter_MaterialsBasicLifeHoursPenaltyFactorControlFromDate' value has been amended then option to re-calculate ALL 'Tightening Date Penalty Hours' and 'Bolt Hours'
 
ALL form(s) :-
Uses 'SystemParameter_HelpPath' to locate help file folder and setup link to Help file ( HtBolts.chm )
 
Bolts Maintenance form :-
dialog Box validates 'Document' file name value ( Documents TAB )
if 'SystemParameter_MaterialsBasicLifeHoursPenaltyFactorControlYN' = 'Y' then uses 'SystemParameter_MaterialsBasicLifeHoursPenaltyFactorControlDescription' where required i.e. '(Kg')' or '(Ka')'
 
Fastener Types Maintenance form :-
if 'SystemParameter_MaterialsBasicLifeHoursPenaltyFactorControlYN' = 'Y' then uses 'SystemParameter_MaterialsBasicLifeHoursPenaltyFactorControlDescription' where required i.e. '(Kg')' or '(Ka')'
 
Temperature Gradient Factors Maintenance form :-
if 'SystemParameter_MaterialsBasicLifeHoursPenaltyFactorControlYN' = 'Y' then uses 'SystemParameter_MaterialsBasicLifeHoursPenaltyFactorControlDescription' where required i.e. '(Kg')' or '(Ka')'
 
Inner Cylinder Stud Factors Maintenance form :-
if 'SystemParameter_MaterialsBasicLifeHoursPenaltyFactorControlYN' = 'Y' then uses 'SystemParameter_MaterialsBasicLifeHoursPenaltyFactorControlDescription' where required i.e. '(Kg')' or '(Ka')'
 
Pitch Circle Diameter Factors Maintenance form :-
if 'SystemParameter_MaterialsBasicLifeHoursPenaltyFactorControlYN' = 'Y' then uses 'SystemParameter_MaterialsBasicLifeHoursPenaltyFactorControlDescription' where required i.e. '(Kg')' or '(Ka')'
 
Reports form :-
NEW version of SAP Crystal Reports ( V13.0.14 , see http://scn.sap.com/docs/DOC-7824 )
Updated ALL reports to latest version of SAP Crystal Reports ( V13.0.14 )
FIXED BUG, 'Materials Basic Life Hours' report - 'Penalty Factor Control' heading
 
Documents Maintenance form :-
dialog Box validates 'Document' file name value
 
Unit Details Maintenance form :-
On closing form, if any 'Unit Operating date' values have been amended then option to re-calculate ALL 'Tightening Date Penalty Hours' and 'Bolt Hours'
 
Main form :-
On opening form, Checks HtBolts32.Net 'Maintenance Contract date' is valid. Displays HtBolts32.Net 'Maintenance Contract date' and 'days left'.

- version 4.02.00.06 - Released Mar 2015.

This version provides new features and enhancements, including :
 
Bolts Maintenance form :-
FIXED BUG, When first Bolt record selected - NO transaction record(s) were displayed.
If 'Additional Hours' entered on Filter form then check if 'Projected Remaining Life Hours' should be displayed RED, AMBER or normal background colour.
If 'Additional Hours' entered on Filter form then check if 'Projected Retighten At Hours' should be displayed RED or normal background colour.
 
System Parameters Maintenance form :-
If 'SystemParameter_AdminPasswordNumber' has NOT been set up with password, then blank 'Value'
When NEW or UPDATING 'NDTRequiredAtHoursFactor' or 'StrainFactorControl' record(s), Check 'Value' is NOT set to zero.
When NEW or UPDATING 'PenaltyFactorControl', 'RemainingLifeHoursControlAmber' or 'RemainingLifeHoursControlRed' record(s), Check 'Value' is NOT set to zero (also remove Thousands Separators).
 
Design Factors Maintenance form :-
When NEW record, set 'Factor (Kd)' to 1.0000 as default.
When NEW or UPDATING record, Check 'Factor (Kd)' is NOT set to zero.
 
Locations Maintenance form :-
When NEW record, set 'Report Factor' to 1.0000 and 'Print Location ?' to 'Y' as default.
When NEW or UPDATING record, Check 'Report factor' is NOT set to zero.
 
Tightening Methods Maintenance form :-
When NEW record, set 'Factor (Kt)' and 'Technique Factor' to 1.0000 as default.
When NEW or UPDATING record, Check 'Factor (Kt)' and 'Technique Factor' is NOT set to zero.
 
Temperature Gradient Factors Maintenance form :-
When NEW record, set 'Factor (Ka)' or 'Factor (Kg)' to 1.0000 as default.
When NEW or UPDATING record, Check 'Factor (Ka)' or 'Factor (Kg)' is NOT set to zero.
 
Inner Cylinder Stud Factors Maintenance form :-
When NEW record, set 'Factor (Ka)' to 1.0000 as default.
When NEW or UPDATING record, Check 'Factor (Ka)' is NOT set to zero.
 
Pitch Circle Diameter Factors Maintenance form :-
When NEW record, set 'Factor (Ka)' to 1.0000 as default.
When NEW or UPDATING record, Check 'Factor (Ka)' is NOT set to zero.

- version 4.02.00.05 - Released Jan 2015.

This version provides new features and enhancements, including :
 
Bolts Maintenance form :-
Allow 'Double-Click', to View or Create a link to an document you have already created and saved using another Application on 'Drawing Details 1', 'Drawing Details 2', 'Estimated Temperature Notes', 'Notes', 'Tightening transaction Notes', 'Nuts Drawing Details' and 'Document'.
TreeView, When selecting 'Unit' or 'Location - 'Disable 'Save NEW record', 'Update CURRENT record' & 'Delete CURRENT record' Menu & Button controls.
TreeView, When selecting 'Unit' or 'Location', Don't display any TABS.
TreeView, Improved performance.
When finished REPLACING Bolt process, display message.
When creating MULTIPLE new tightening transactions, display progress bar.
FIXED BUG, When ADDING new tightening transaction or MULTIPLE tightening transactions, it sometimes created duplicates.
FIXED BUG, When UPDATING tightening transaction, it sometimes created duplicates.
FIXED BUG, When REPLACING tightening transactions, it sometimes created duplicates.
 
Documents Maintenance form - Allow 'Double-Click', to View or Create a link to an document you have already created and saved using another Application on Document.
 
Filter form - When combo box(s) item not selected, clear description.
 
Unit Maintenance form - When UPDATING Unit Code, don't blank UNITDETAILS date combo box.
 
Materials Basic Life Hours Maintenance form - After NEW or UPDATING record then display Option to refresh records, or not.
 
System Parameters Maintenance form :-
NEW System Parameter - 'AdminPasswordNumber' (encrypted).
before UPDATING record(s), improved validation of 'Value'.
 
Maintenance form(s) - If NEW System Parameter - 'AdminPasswordNumber' (encrypted) is setup to ask for 'Admin Password', then 'Admin Password' is required before the following forms :-
Design Factors
Fastener Types
Materials
Materials Basic Life Hours
Tightening Methods
Systems Parameters
Temperature Gradient Factors
Inner Cylinder Stud Factors
Pitch Circle Diameter Factors
 
Reports form - When the Report(s) are being created, display a wait cursor.

- version 4.02.00.04 - Released Jan 2014.

This version provides new features and enhancements, including :
 
Bolts Maintenance form :-
TreeView, When opening and closing 'Units' and 'Locations', Improved performance.
After Adding/Updating/Deleting Bolts - If System Parameter - 'PopulateBoltsTreeViewDataOnInitialLoad' = 'N' then Open filter form otherwise Refresh All Treeview Records.
Refresh option - If System Parameter - 'PopulateBoltsTreeViewDataOnInitialLoad' = 'N' then Open filter form otherwise Refresh All Treeview Records.
FIXED BUG, Amendment of Temperature Gradient Factor (Ka or Kg) , Inner Cylinder Stud or Pitch Circle Diameter.
Improved performance, Updating 'ALL' Tightening Dates Penalty Hours.
Using Unit Details Date, Display 'First' and 'Last' Penalty Hours correctly, (including Treeview).
 
Reports - Using Unit Details Date, display 'First' and 'Last' Penalty Hours correctly.

- version 4.02.00.03 - Released Jul 2013.

This version provides new features and enhancements, including :
 
NEW System Parameter - 'DisplayOptionToPopulateRemainingLocationBoltTighteningDateRecordsWithCurrentRecordYN'.
 
Bolts Maintenance form - After adding NEW Tightening record - If System Parameter - 'DisplayOptionToPopulateRemainingLocationBoltTighteningDateRecordsWithCurrentRecordYN' = 'Y' then user has option to populate 'ALL' remaining location bolt tightening date record(s) with 'current' tightening date record details.

- version 4.02.00.02 - Released May 2013.

This version provides new features and enhancements, including :
 
Bolts Maintenance form - Amended 'Thread Systems' lookup control.
 
Help File(s) - Changed heading to 'HtBolts32.Net - High Temperature Bolts Database Management System'.
 
All forms - Added latest form controls.
 
All Reports - Added latest report controls.
 
Splash form - FIXED BUG (intermittant), were throws 'Invoke or BeginInvoke cannot be called on a control until the window handle has been created' Exception.

- version 4.02.00.01 - Released Apr 2013.

This version provides new features and enhancements, including :
 
All forms - When filtering (new BinaryComboBox.dll) retains column sizes and removed 'ID' column from all filters (Except Switch Installations)
 
Bolts Maintenance form :-
Allow same document(s) for multiple Bolt records.
Clear Filter for 'Additional Hours' when closing form.
 
Reports form - Allow 'Double-Click' or 'Return key' to select report(s) and clears Filter for 'Additional Hours' when closing form.
 
Help File(s) - Changed '< 22m' to '< 22mm' and '> 22m' to '> 22mm'

- version 4.02.00.00 - Released Feb 2013.

This version provides new features and enhancements, including :
 
NEW Attributes - 'LOCATIONS.REPORTFACTOR' and 'LOCATIONS.REPORTYN'.
 
Locations Maintenance form - Display 'Report Factor' and 'Print Location?'.
 
Locations report - Display 'Report Factor' and 'Print Location?'.
 
Bolt Summary report :-
Added Locations 'Report Factor' and 'Print Location?' to report criteria.
Amended 'Average Penalty Hours' column heading to 'Projected Penalty Hours'
Amended 'Average Penalty Hours' multiplied by Locations 'Report Factor

- version 4.01.00.03 - Released Nov 2012.

This version provides new features and enhancements, including :
 
Added ALL GENSIP documentation to Help File.
 
Maintenance form(s) :-
If System Parameter - 'MaterialsBasicLifeHoursPenaltyFactorControlYN' = 'Y' then display 'Factor (Kg)' , otherwise display 'Factor (Ka)' for 'GRADIENTFACTORS', 'ICSFACTORS' and 'PCDFACTORS'.
If System Parameter - 'MaterialsBasicLifeHoursPenaltyFactorControlYN' = 'Y' then display 'Use Gradient Factor (Kg)' , otherwise display 'Use Gradient Factor (Ka)' for 'FASTENERTYPES'.
 
Filter form :-
If System Parameter - 'MaterialsBasicLifeHoursPenaltyFactorControlYN' = 'Y' then display 'Factor (Kg)' , otherwise display 'Factor (Ka)' for 'GRADIENTFACTORS', 'ICSFACTORS' and 'PCDFACTORS'.
If System Parameter - 'MaterialsBasicLifeHoursPenaltyFactorControlYN' = 'Y' then display 'Use Gradient Factor (Kg)' , otherwise display 'Use Gradient Factor (Ka)' for 'FASTENERTYPES'.
 
Bolts Maintenance form - If System Parameter - 'MaterialsBasicLifeHoursPenaltyFactorControlYN' = 'Y' then display '(Kg)' , otherwise display '(Ka)' for 'BOLTS'.
 
Added Confirm Exit dialog when closing HtBolts32.Net.

- version 4.01.00.02 - Released Nov 2012.

This version provides new features and enhancements, including :
 
NEW Attribute - 'MATERIALSBASICLIFEHOURS.PENALTYFACTORCONTROL'.
NEW System Parameter - 'MaterialsBasicLifeHoursPenaltyFactorControlYN'.
 

Help File(s) includes GENSIP. Added new pages for changes below.

 
Materials Basic Life Hours Maintenance form - Display 'Penalty Factor Control'.
 
Materials Basic Life Hours report - Display 'Basic Life Hours' and 'Penalty Factor Control'.
 
Bolts Detail report - Display 'Materials Basic Life Hours Penalty Factor Control'.
 
Bolts Maintenance form :-
Added 'Materials Basic Life Hours Penalty Factor Control' in 'Materials Basic Life Hours' Combo control.
Display 'Basic Life Hours Penalty Factor Control' on 'Bolts' TAB.
If System Parameter - 'MaterialsBasicLifeHoursPenaltyFactorControlYN' = 'Y' then display 'Materials Basic Life Hours Penalty Factor Control' on 'Tightenings' TAB.
 
FIXED BUG, only update Tightening record LASTUPDATED and UPDATEDBY when Tightening record individually updated.
FIXED BUG, only update Bolt record LASTUPDATED and UPDATEDBY when Bolt record individually updated.

- version 4.00.00.02 - Released Sep 2012.

This version provides new features and enhancements, including :
 
NEW System Parameter - 'TypeOfAdditionalPenaltyHours'.
NEW System Parameter - 'TypeOfReplaceBoltTighteningDatesRecord'.
 
Help File(s) consolidated i.e. HtBolts, GEOM85 & BEOM102. Added new pages for changes below. Added Browse sequences.
 
Unit Operating Details form - When adding new Unit details record(s), NEW option to update 'UNITS' table with new 'UNITSDETAILS' record (1 action, previously 2 actions).
 
Main form - If new Installation selected then resize form(s) accordingly.
 
Bolt Summary report - Added 'Location description' and amended heading 'Unit Code' to 'Unit'.
 
Units Operating Details report - Amended heading 'Unit Code' to 'Unit'.
 
Report form - Clear current Report after new report is selected.
 
Bolts Maintenance form :-
NEW option to display 'FIRST', 'LAST', 'MINIMUM', 'MAXIMUM' or 'AVERAGE' Penalty Hours.
NEW option to Replace Bolt record, creates 'FIRST' or 'LAST' Bolt Tightening record (with latest Unit Details information). Enable Replace (Button & Menu) only when Bolt record selected, otherwise disabled.
Enable COPY Tightening record (Button & Menu) only when Bolt record selected, otherwise disabled.
Enable PASTE Tightening record (Button & Menu) only when Bolt record selected, otherwise disabled

- version 4.00.00.01 - Released Jun 2012.

This version provides new features and enhancements, including :
 
NEW System Parameter - 'ReportsPath'.
NEW System Parameter - 'NDTRequiredAtHoursSubtractAccruedPenaltyHoursYN'.
 
About form - Added 'http://www.columnsystems.co.uk/' link.
 
NEW 'Replace Bolt' menu option.
 
Report form - Added 'Company name' to header.
 
Bolts Maintenance form :-
Increased size of 'Advice' field
NEW option to Subtract 'Accrued Penalty Hours' from 'NDT Required at hours'.
Increased size of 'Materials Basic Life Hours' description textbox.
Increased size of 'Thread Systems' comboBox i.e. 'Pitch' and 'No of Threads'.
If Shank Length (or Effective Length) is <= '0.0000' then highlight in AMBER background
 
System Parameters Maintenance form - Increased size of System Parameters 'Code' textbox.
 
Reports form - When report selected, displays dialog Box to confirm Report selection is required i.e. Continue to print 'Anti Seizes' report? - Please Note! Processing the report can take a few moments......
 
Maintenance forms :-
When closing, If user confirms to 'update ALL Tightening records', then DON'T update 'LASTUPDATED' & 'UPDATEDBY' in 'BOLTSTIGHTENINGDATES' table.
When closing, If user confirms to 'update ALL Bolt records', then DON'T update 'LASTUPDATED' & 'UPDATEDBY' in 'BOLTS' table.

- version 4.00.00.00 - Released Mar 2012.

This version provides ease-of-use and speed enhancements as well as new features.
In this release, you'll find speed improvements and enhancements in basic features and common tasks, making the program easier to use. New users will also benefit from descriptive tool tips and other user interface improvements.
 
Client Application: using Microsoft VB.Net programming language.
Databases: SQL Server, Oracle & Access.
Operating Systems: All Window versions.
NEW 'Multi site' capability.
NEW 'Bolts Tree View' Hierarchy structure.
NEW 'Thread Systems' table.
NEW 'Reports' (15) plus Enhanced Reporting features i.e. 'drill-down' facility.
NEW 'Display, Print and Update Projections' when Bolts are to be 'REPLACED' or 'RETIGHTENED'.
NEW 'Independant primary keys' - i.e. facility to amend 'Locations' Code but not lose links to Bolt record(s).
NEW 'feature' to determine whether tightening records update the 'Bolt Retighten At Hours', or not. i.e. leak sealing.
NEW 'Web HTML' Help files.
NEW 'Multiple' screen resolutions capability.
Enhanced 'Data Filtering' & 'column sorting' of information.
Enhanced 'Auditing' facilities.
Enhanced 'Document handling'.
Designed to comply with GOM85 and BEOM102 (NEOM102).
and much much more ........


HtBolts32

- version 3.12 - Released Feb 2012.


Thank you, we hope you found this information useful and informative.
all_pix_trans.gif (807 bytes)
Copyright © 2010 Column Systems Ltd. All rights reserved.
Diamond House. Diamond Court. Water Street.
Bakewell. Derbyshire. DE45 1EW.
T +44 (0) 1246 569707
M +44 (0) 797 061 3831
E info@columnsystems.co.uk
Business VAT no: GB 643 6782 14
Company Registration no: 02957908
Place of Registration: England