Table Settings

This can be used to add new fields to the tables in the database or delete fields you no longer need.  

Add Field - For instance, if you want to add a new field to the Calibration Info data entry page,

•Check the "Calibration Data Table" button

•Enter the new name for the field. Letters only and no spaces or special characters. Don't use any reserved words of the SQL language, like "order", "date", "procedure", etc.

•Choose field type:

•Integer - for only numbers without decimal points.

•Text(50 characters) - will handle most needs.

•Memo(unlimited text) - when you have multi-lines of text.

•Date - for dates.

•Decimal - when numbers with decimal points needed.

•Boolean - for yes/no. Displays check box.

•Press "Add Field" button.

Then go to the Calibration or Database Settings tab and you can add that new database field that you just made with the Calibration Results Columns. The new field name will appear in the Fieldname dropdown list.

To delete a field enter the field name and press "Delete Field". 

Delete Field - Choose which table, enter the field name in the box, press Delete Field button.

Clean Database - When you delete gages the linked test points and calibrations are deleted too. But if you have deleted items externally, or you think you may have orphaned items in the database this button will look look for all orphans and delete them.

These items are only enabled with administrator privileges.

Required Fields - Certain fields are required in the database tables or program will not work:

Gagemaster table:

•Gage_ID: AutoIncrement

•GageSN : Text

•Frequency : Float

•Active : Boolean

•CheckedOut : Integer

•DueDate  : Date

CalibrationHeader:

•Calibration_ID: AutoIncrement

•Gage_ID : Integer

•CalibrationDate: Date

CalibrationColumns:

•ID: AutoIncrement

•Order : Integer

•Heading : Text

•FieldName : Text

•ListItems : Memo

GageColumns:

•ID: AutoIncrement

•Order : Integer

•Heading : Text

•FieldName : Text

•ListItems : Memo

Groupaccess:

•ID: AutoIncrement

•GroupName : Text

•Permission : Text

GroupMembers:

•ID: AutoIncrement

•UserName : Text

•GroupName : Text

Groups:

•GroupID: AutoIncrement

•GroupName : Text

•Description : Text

Permissions:

•ID: AutoIncrement

•Permission : Text

•Items : Text

•Action : Integer

•FormName : Text

TestPointResults:

•TestPointResults_ID: AutoIncrement

•Calibration_ID : Integer

•TestPoint_ID : Integer

•Result : Text

TestPoints:

•TestPoint_ID: AutoIncrement

•Gage_ID : Integer

•SN : Text

•Test_Point : Text

UserAccess:

•ID: AutoIncrement

•UserName : Text

•Permission : Text

Users:

•UserID: AutoIncrement

•LoginName : Text

•FullName : Text

•Password : Text

•LastAccess : DateTime

•Enabled : Boolean

•CreatedDate : DateTime

•LastAccTime : DateTime

•CreatedTime : DateTime

•AccessCount : Integer

Displaying a dropdown Memo Editor in the grid . Any field that has "memo" in the field name will be displayed with a button in the edit box and when clicked will display the dropdown edit box that has the memo field text in it. (like: "gagememo"). The field must be put in the Displayed Fields settings for it to take effect.

Boolean Fields - Boolean fields will show up as checkboxes in the grids. Different brands of databases use different definitions for boolean fields. Access uses "Yes/No" fields. MySQL uses "tinyint". Oracle uses NUMBER(1,0). If you use these, the field should show up as a checkbox in the grid column.