Database Component
The InfinityQS ProFicient Database component is included as part of the Custom Software License (CSL). It is an ActiveX library that can be used to access most ProFicient Database resources. The purpose of this document is to describe how to use the Database component.
Getting Started
To prepare the initial software development environment, please refer to the Custom Software License (CSL) reference material.
The topics below will help introduce the Database component and some of its more commonly used features. While most samples were created using VB6, they provide enough detail to benefit any developer and any software development platform that supports COM.
To begin using the Component:
- Begin or open an existing project
- Within the project reference the InfinityQS ProFicient Database component
See the Custom Software License (CSL) for more assistance getting started.
Using the Database Object
Within the Database component, the Database Object is the most frequently used. It provides the physical connection to an InfinityQS database.
Not only do most the other objects in this component need a reference to a "connected" Database object, but many other ProFicient components in throughout Custom Software License (CSL) require a Database object reference as well.
Database Object Lifetime
It is recommended that the Database object be maintained or kept alive. This because it will take additional processor time to continually re-instantiate, re-authenticate and then re-connect each time a database object is needed.
To keep an instance of an object alive, it should be declared at the module level. Add the following code to the General Section of a VB6 Form or Class.
Option Explicit
Private WithEvents moDatabase As iiaDatabase6.Database
It is not absolutely necessary to keep the database object or its connection maintained. In some cases, a module-level Database object can be maintained and Authenticated. Only when a connection is needed is the Connect method called followed by Disconnect once data access is no longer needed.
Connecting to any ProFicient Database
With the Database object, the user can be prompted to select a ProFicient database each time the application starts. The following VB6 sample demonstrates this within a module. In the Project Properites the Startup Object is set to Sub Main.
- Add a Module (BAS) to the project and enter the following code sample.
- Run the program.
- The Select Data Source dialog is presented. Choose any ProFicient data source.
- The ProFicient Sign In dialog is displayed. Enter a valid name and password (e.g. Name = Admin, Password = admin). Consult with the IT department if unable to successfully sign in.
- If connected successfully, Form1 will display normally. Otherwise an error is displayed and the application ends.
Option Explicit
'PUBLIC OBJECTS CAN BE ACCESSED FROM ANY OTHER MODULE
Public moDatabase As iiaDatabase6.Database
Private Sub Main()
'Initialize the database object
Set moDatabase = New iiaDatabase6.Database
'It must be authenticated before it can be used.
'CSL DEVELOPERS: Use a Long Integer Handle (hWnd) or a Clng(0)
'PSL DEVELOPERS: Use Registration Code
moDatabase.Authenticate Me.hWnd
If moDatabase.Connect = False Then
MsgBox "No Database Connection!"
End
End If
End Sub
Connecting to a Specific ProFicient Database
The Database object can be configured to automatically connect to a specific Data Source Name (DSN). This way the user does not get to choose the data source, but is still prompted to sign in to the ProFicient database. The following VB6 sample code can be placed in a Standard Visual Basic project's Form.
- Add a Command Button to Form1 and name it bnLogin. Set its Caption to "Login". Double-click the button and add the following Code to the bnLogin_Click procedure. (Note: Use only one of the two Authenticate methods shown within this sample.)
- Run the program and click the Login button.
- The database login window is presented. Enter a valid name and password (e.g. Name = Admin, Password = admin). Consult with the IT department if unable to successfully sign in.
- A message box will indicate whether the connection was established successfully or not.
Expected Result
Private Sub bnLogin_Click()
'Initialize the database object if necessary.
If moDatabase Is Nothing Then
Set moDatabase = New iiaDatabase6.Database
'It must be authenticated before it can be used.
'CSL DEVELOPERS: Use a Long Integer Handle (hWnd) or a Clng(0)
'PSL DEVELOPERS: Use Registration Code
moDatabase.Authenticate Me.hWnd
moDatabase.DSN = "InfinityQS ProFicient Examples"
End If
If moDatabase.Connect Then
MsgBox "Login was successful."
Else
MsgBox "Login Failed!"
End If
End Sub
Automatically Signing In to a ProFicient Database
The Database object can be configured to sign in automatically with a User Name and Password. The following VBScript code example specifies the DSN, the User Name and Password.
Dim oDatabase
Set oDatabase = CreateObject("iiaDatabase6.Database")
oDatabase.Authenticate 0
oDatabase.DSN = "InfinityQS ProFicient Examples"
oDatabase.UserName = "Admin"
oDatabase.Password = "admin"
oDatabase.Connect
MsgBox "IsConnected = " & oDatabase.IsConnected
If the above VBS successfully connects to a ProFicient Database a message box will display "IsConnected = True". Otherwise it will display "False".
Suppress Database Error Messages
If the Database object will be used within a windowless environment where error messages cannot be presented, use the PostErrors property to disable all error messages.
moDatabase.PostErrors LogNoErrors
Accessing Tables using Table Objects
Most of the objects within the Database component provide access to InfinityQS Database tables. They are referred to as "Table objects" and each have a similar software interface.
Following is a list of all Table objects provided by the InfinityQS ProFicient Database component. The list is organized based on a description of each InfinityQS table, followed by the Table Object name and then followed by the actual database table name.
Table Object |
Table Description |
Table Name |
---|---|---|
Assignable Cause Code |
ACC_DAT |
|
Access Failure Log |
ACC_FAIL |
|
Assignable Cause Group |
ACC_GRP |
|
Assignable Cause Linkage |
ACC_LINK |
|
Assignable Cause Linkage View |
ACC_LINK_V |
|
Access Log |
ACC_LOG |
|
Alarm Rule Assignments |
ALR_RULE |
|
Area Information |
AREA_INF |
|
Corrective Action Code |
CAC_DAT |
|
Corrective Action Group |
CAC_GRP |
|
Calibration Comments |
CAL_CMT |
|
Calibration Data |
CAL_DAT |
|
Calibration Information |
CAL_INF |
|
Company Information |
CO_INF |
|
Control Limits |
CTRL_LIM |
|
Control Limit Subgroups |
CTRL_SGRP |
|
Database Information |
DB_INF |
|
Defect/Defective Code |
DEF_DAT |
|
Defect/Defective Group |
DEF_GRP |
|
Defect Opportunities |
DEF_OPP |
|
Department Information |
DEPT_INF |
|
Descriptor |
DESC_DAT |
|
Descriptor Category |
DESC_GRP |
|
Division Information |
DIV_INF |
|
Employee Information |
EMPL_INF |
|
Employee Password History |
EMPL_PCH |
|
Employee Security |
EMPL_SEC |
|
Employee Extra |
EMPL_XTR |
|
Event Notes |
EVNT_CMT |
|
Event Information |
EVNT_INF |
|
Gage Information |
GAGE_INF |
|
Gage Location (View) |
GAGE_LOC |
|
Gage Model |
GAGE_MDL |
|
Gage Movement |
GAGE_MOV |
|
Gage Reference |
GAGE_REF |
|
Gage Type |
GAGE_TYP |
|
Gage Model Reference |
GMDL_REF |
|
Gage Study Comments |
GRR_CMT |
|
Gage Study Data |
GRR_DAT |
|
Gage Study Data (View) |
GRR_EXT |
|
Gage Study Information |
GRR_INF |
|
Gage Study Summary |
GRR_SUM |
|
Job |
JOB_DAT |
|
Job Descriptors |
JOB_DSC |
|
Job Group |
JOB_GRP |
|
Job Operation |
JOB_OP |
|
Job Operation Descriptors |
JOB_OP_DSC |
|
Job Operation Lot |
JOB_OP_LOT |
|
Job Operation Process |
JOB_OP_PRCS |
|
Job Summary |
JOB_SUM |
|
Language Resource |
LNG_DAT |
|
Language Type |
LNG_TYP |
|
Lot Acceptance Sampling Requirements |
LOT_AC_REQ |
|
Lot Acceptance Sampling Summary |
LOT_AC_SUM |
|
Lot Summary |
LOT_SUM |
|
Measurement Type |
MEAS_TYP |
|
Network Information |
NET_INF |
|
Part |
PART_DAT |
|
Part Group |
PART_GRP |
|
Lot |
PART_LOT |
|
Part Serial Number |
PART_SN |
|
Part/Test Information |
PART_TEST |
|
Procedure Data |
PRCD_DAT |
|
Procedure Information |
PRCD_INF |
|
Process |
PRCS_DAT |
|
Process Group |
PRCS_GRP |
|
Process Unit |
PRCS_UNT |
|
Requirement Data |
REQU_DAT |
|
Requirement Information |
REQU_INF |
|
Reason for Change Code |
RFC_CODE |
|
Reason for Change |
RFC_INF |
|
Alarm Rule Definitions |
RULE_DEF |
|
Role Information |
SECU_INF |
|
Role Extra |
SECU_XTR |
|
Subgroup Comments |
SGRP_CMT |
|
Subgroup Descriptors |
SGRP_DSC |
|
Subgroup Data (View) |
SGRP_EXT |
|
Subgroup Information |
SGRP_INF |
|
Subgroup Component Lots |
SGRP_LOT |
|
Subgroup Tests |
SGRP_TST |
|
Shift |
SHFT_DAT |
|
Shift Group |
SHFT_GRP |
|
Site Information |
SITE_INF |
|
SPC Email Notification |
SPC_MAIL |
|
Specification Limits |
SPEC_LIM |
|
Tests/Features |
TEST_DAT |
|
Test/Feature Group |
TEST_GRP |
|
Unit Type |
UNIT_TYP |
|
Workstation Information |
WKST_INF |
|
Workstation Extended Information |
WKST_EXT |
Table Object Disclaimer
Understanding how to use the Accessing Tables using Table Objects to gain access to ProFicient tables is only the beginning. These objects do not offer an understanding of table schema. Nor, are they forgiving in any way. If a table object is instructed to delete all records that is precisely what it will do. If the Edit method is used carelessly, every record within the table could be affected rather than the single record that was probably intended.
Learning more about ProFicient Tables
There are various ways to learn more about the ProFicient Tables and the purposes they serve within the ProFicient Quality Suite.
A great place to start is by reviewing the table definitions listed within the InfinityQS Database Manager utility. It provides a list of tables and their table definitions. It includes a listing of every field name, a field description, its data type, and its constraints and references.
A clear understanding of the ProFicient Quality Suite and how it is being used within your organization is also beneficial. For example, before working with the SpecLim object, consider learning more about Specification Limits and how they are used by your company.
Backup the ProFicient Database
During software development, it is good practice to work off-line from the master database. Consider making a copy of the database while developing and testing. Most Database Management Systems provide their own database cloning features. InfinityQS Database Manager also provides a Database Dump and Load Utility as well.
If it is not possible to make a database clone, at the very least, make sure there is a recent backup of the master database before running the new software project on that database.
Field Properties
Every ProFicient table includes a unique collection of fields. Likewise, every corresponding Accessing Tables using Table Objects includes a unique set of "Field Properties" (e.g. Part, Test, Usl, Lsl, etc). Many of the table objects, such as the PartGrp object, for example, include a "Name" field property which corresponds with the table's F_NAME field. The following code example demonstrates the use of the field properties, "Name", "Text" and "Fctr" to Add a new Part Group to the database.
Dim oPartGrp As iiaDatabase6.PartGrp
Set oPartGrp = New iiaDatabase6.PartGrp
oPartGrp.Name = "Colored Parts"
oPartGrp.Text = "Used in Shaft Diameters SPC Project"
oPartGrp.Fctr = 100.5
If oPartGrp.Add(moDatabase) Then MsgBox "Part Group Added Successfully."
'SQL STATEMENT (ACTUAL F_PTGP NUMBER IS AUTO-GENERATED AT RUNTIME)
'INSERT INTO PART_GRP(F_PTGP, F_NAME, F_TEXT, F_FCTR)
'VALUES(1234567,'Colored Parts','Used in Shaft Diameters SPC Project',100.5)
Field Flag Properties
With every Field Properties is a corresponding "Field Flag Property". For example, the PartGrp object includes a "Name" property and a "NameFlag" property, among many others. Field Flag Properties are used by Find Function (Table Objects), Count Property, Edit Function and Delete Function. Within these methods, Field Flag Properties have the following responsibilities.
- Filtering ? Field flags can be used for filtering the records included in a Find, Count, Edit or Delete. (It builds up the WHERE portion of the SQL Statement.)
- Sorting ? Field flags can determine the order in which records are returned during Find. (It builds up the ORDER BY portion of the SQL statement).
- Updating Fields ? Field flags define which fields to update during Edit.
Field flag properties are data typed as SQLFlagConstants. The following code example uses the NameFlag property to return only the records equal to the specified Name property.
Dim oPartGrp As iiaDatabase6.PartGrp
Set oPartGrp = New iiaDatabase6.PartGrp
oPartGrp.Name = "Colored Parts"
oPartGrp.NameFlag = WhereEqual
If oPartGrp.Find(moDatabase) Then MsgBox "Found ID: " & oPartGrp.Ptgp
'SQL STATEMENT
'SELECT * FROM PART_GRP WHERE F_NAME='Colored Parts'
To combine multiple responsibilities, such as Filtering and Sorting, multiple SQLFlagConstants can be combined by ORing their values. The following code example uses the FctrFlag to return records where Fctr is greater or equal to "1" (a filtering responsibility). And FctrFlag further requests that records be sorted by Fctr values (a sorting responsibility).
Dim oDefDat As New iiaDatabase6.DefDat
oDefDat.Buffer = 10000
oDefDat.Fctr = 1
oDefDat.FctrFlag = WhereGreaterEqual Or OrderByAscending
If oDefDat.Find(moDatabase) Then
Do
List1.AddItem oDefDat.Name & " (" & oDefDat.Fctr & ")"
Loop While oDefDat.NextRec
End If
'SQL STATEMENT
'SELECT * FROM DEF_DAT WHERE F_FCTR >=1 ORDER BY F_FCTR
Finding Records
Each Accessing Tables using Table Objects includes a Find Function (Table Objects) method.
Finding a Single Record
The following code example demonstrates how to locate a single test based on its Name.
Dim oTestDat As iiaDatabase6.TestDat
Set oTestDat = New iiaDatabase6.TestDat
oTestDat.Name = "OD - Loc A"
oTestDat.NameFlag = WhereEqual
If oTestDat.Find(moDatabase) Then MsgBox "Found ID: " & oTestDat.Test
'SQL STATEMENT EQUIVALENT
'SELECT * FROM TEST_DAT WHERE F_NAME='OD - Loc A'
Finding Multiple Records
By default, Accessing Tables using Table Objects only return a single record. To request multiple records, set the Buffer Property property to a value sufficient to get the desired number of records.
The following code example queries the Defect Group table and displays each name in a list box. Each list item's ItemData property is also assigned the record's ID.
Dim oDefGrp As iiaDatabase6.DefGrp
Set oDefGrp = New iiaDatabase6.DefGrp
List1.Clear
oDefGrp.Buffer = 10000
If oDefGrp.Find(moDatabase) Then
Do
List1.AddItem oDefGrp.Name
List1.ItemData(List1.NewIndex) = oDefGrp.Dfgp
Loop While oDefGrp.NextRec
End If
'SQL STATEMENT EQUIVALENT
'SELECT * FROM DEF_GRP
Code Example Results
Finding Multiple Sorted Records
Field Flag Properties can be used to define the order of queried results. The following code example creates a list of defect groups, ordered by Name.
Dim oDefGrp As iiaDatabase6.DefGrp
Set oDefGrp = New iiaDatabase6.DefGrp
List1.Clear
oDefGrp.Buffer = 10000
oDefGrp.NameFlag = OrderByAscending
If oDefGrp.Find(moDatabase) Then
Do
List1.AddItem oDefGrp.Name
List1.ItemData(List1.NewIndex) = oDefGrp.Dfgp
Loop While oDefGrp.NextRec
End If
'SQL STATEMENT EQUIVALENT
'SELECT * FROM DEF_GRP ORDER BY F_NAME
Code Example Results
Resolving a Name from an ID
The following code example takes the TestDat object's Tsgp (test group id) and queries the Test Group table for actual group name.
Dim oTestGrp As iiaDatabase6.TestGrp
Set oTestGrp = New iiaDatabase6.TestGrp
oTestGrp.Tsgp = oTestDat.Tsgp
oTestGrp.TsgpFlag = WhereEqual
If oTestGrp.Find(moDatabase) Then MsgBox "Group Name: " & oTestGrp.Name
'SQL STATEMENT EQUIVALENT (ACTUAL NUMERIC VALUE IS UNKNOWN)
'SELECT * FROM TEST_GRP WHERE F_TSGP=9122343
Counting Records
Finding Records and counting records are similar in concept. But because records are only counted (not returned), the Buffer Property property is ignored by the Count method.
The following example counts the total number of specification limit records within a ProFicient database.
Dim oSpecLim As New iiaDatabase6.SpecLim
MsgBox oSpecLim.Count(moDatabase)
'SQL STATEMENT EQUIVALENT
'SELECT COUNT(*) FROM SPEC_LIM
Adding Records
Accessing Tables using Table Objects can be used to add records to InfinityQS tables (not views).
NOTE: Be sure to have a clear understanding of the table being written to. And further consider the table's impact within the ProFicient QualitySuite.
There are some basic rules to consider when writing records to the database.
Primary Key Constraint
Most (but not all) record types include a single-field Primary Key constraint. When reviewing table definitions from Database Manager, for example, look for a field marked as primary (P), but not foreign (F). This Field will be automatically assigned by the Add method.
Foreign Key Constraint
Fields marked as Foreign within the Table Definitions must be assigned a valid value that exists within the defined reference table and field.
Consider the following VBScript sample.
Dim oDatabase
Set oDatabase = CreateObject("iiaDatabase6.Database")
oDatabase.Authenticate 0
oDatabase.DSN = "InfinityQS ProFicient Examples"
oDatabase.UserName = "Admin"
oDatabase.Password = "admin"
oDatabase.Connect
If oDatabase.IsConnected Then
Dim oPartDat
Set oPartDat = CreateObject("iiaDatabase6.PartDat")
oPartDat.Name = "Hello World"
oPartDat.Add(oDatabase)
End If
Ptgp must be assigned to a valid part group record or the above code snippet will generate an error when the Add method is called.
Unique Constraints
Fields marked as unique must be specified and must be unique. Some tables may include multi-field unique constraints (e.g. DefDat is unique by Defect Group and Name). These multi-field unique constraints are applied together. (E.g. Defect codes can have the same Name, but only if assigned a different Dfgp).
Consider the following VBScript sample.
Dim oDatabase
Set oDatabase = CreateObject("iiaDatabase6.Database")
oDatabase.Authenticate 0
oDatabase.DSN = "InfinityQS ProFicient Examples"
oDatabase.UserName = "Admin"
oDatabase.Password = "admin"
oDatabase.Connect
If oDatabase.IsConnected Then
'Get Part Group
Dim oPartGrp
Set oPartGrp = CreateObject("iiaDatabase6.PartGrp")
oPartGrp.Name = "Global Parts"
oPartGrp.Add(oDatabase)
End If
PartGrp.Name must be unique. If the specified name already exists in the ProFicient database, an error will occur when the Add method is called.
Auto-Assigned Fields
In addition to the primary key, do not set the Crtm, Edtm, and User properties, as they are defined automatically by the Add method. The Create Time and Edit Time are assigned the computer's current time, and User is set based on the currently logged in user.
The following example demonstrates how to add a Specification Limit record to the database.
Dim oSpecLim As New iiaDatabase6.SpecLim
oSpecLim.Part = lngPartID 'Valid Part Id
oSpecLim.Test = lngTestID 'Valid Test Id
oSpecLim.Eflag = UseLSL Or UseTAR Or UseUSL
oSpecLim.Usl = dblUpper
oSpecLim.Tar = dlbTarget
oSpecLim.Lsl = dlbLower
If oSpecLim.Add(moDatabase) Then MsgBox "Success!"
Editing Records
Accessing Tables using Table Objects can be used to modify one or more records within an InfinityQS table (not view).
NOTE: Be sure to have a clear understanding of the table being updated. And further consider the table's impact within the InfinityQS SPC Suite. See Risk Assessment for more on this subject.
NOTE: An Edit cannot be undone!
There are some basic guidelines to consider when updating records.
- Most importantly, consult the table definitions to verify no constraints will be violated.
- The Field defined as Primary, but not Foreign (as noted within the Table Definitions), cannot be modified.
- Verify an appropriate filter has been defined to prevent "every" record within the table from being changed. See Field Flag Properties for more on filtering.
- Do not set the Crtm, Edtm, and User properties, as they are defined automatically by the Edit method. The Create Time will remain unchanged. The Edit Time is assigned the computer's current time, and User is updated based on the currently logged in user.
The following example code updates the factor value for the "Bent Drill Bit" Assignable Cause Code.
Dim oAccDat As New iiaDatabase6.AccDat
oAccDat.Name = "Bent Drill Bit"
oAccDat.NameFlag = WhereEqual
oAccDat.Fctr = 175.5
oAccDat.FctrFlag = UpdateField
If oAccDat.Edit(moDatabase) Then MsgBox "Success!"
Deleting Records
Accessing Tables using Table Objects can be used to delete one or more records of an InfinityQS table (not view).
NOTE: Be sure to have a clear understanding of the table being updated. And further consider the table's impact within the InfinityQS SPC Suite. See Risk Assessment for more on this subject.
NOTE: This Delete method supports "cascade delete" functionality. That is, if a 'Parent' record is deleted, all of its sibling records and those records' sibling records (and so on) are also removed from the database. For example, when a Part Group is deleted, all of its Parts are deleted. And for each deleted part record, its associated specification limits, control limits and subgroups are deleted.
There are some basic guidelines to consider when deleting records.
- Most importantly, consult the table definitions to verify no constraints will be violated. This method supports cascade deletes.
- Verify an appropriate filter has been defined to prevent "every" record within the table from being changed. See Field Flag Properties for more on filtering.
The following example code deletes a Part Group and all of its related records (and their related records, and so on) from the database.
Dim oPartGrp As New iiaDatabase6.PartGrp
oPartGrp.Ptgp = 1095245475
oPartGrp.PtgpFlag = WhereEqual
If oPartGrp.Delete(moDatabase) Then MsgBox "Success!"
Converting between Long and Date
Many Accessing Tables using Table Objects properties have the Long Integer data type. Yet, their values actually represent a date/time value. These long values are represented as "the number of seconds since January 1, 1970".
The following code example demonstrates how to convert a Long Integer (lngDateTime) into a Date (datDateTime).
datDateTime = VBA.DateAdd("s", lngDateTime, "1/1/70")
The following code example demonstrates how to convert a Date (datDateTime) into a Long Integer (lngDateTime).
lngDateTime = VBA.DateDiff("s", "1/1/70", datDateTime)
Database Component Object Model
The following topics are organized into Objects, Properties, Methods, Events and Constants.
Objects
Most of the objects within the database component are Accessing Tables using Table Objects. They directly correspond with an InfinityQS database table. But there are other specialized objects as well.
- Buffer Object ? The Buffer object can be used as a simple repository for maintaining basic database information.
- Database Object ? Everything revolves around the Database object. It represents the physical database connection and is required by most other objects.
- DatabaseInformation Object ? This object is reserved for internal use only.
- DatabaseManager Object ? This object is reserved for internal use only.
- FieldDefinition Object ? This object is reserved for internal use only.
- SPCMailRecipient Object ? This specialized object returns an EmplInf object containing an appropriate collection of SPC Mail Recipients.
- TableDefinition Object ? This object is reserved for internal use only.
AccDat Object
The AccDat object provides access to the Assignable Cause Codes table.
Properties
Abbr Property, AbbrFlag Property, Acc Property, AccFlag Property, Acgp Property, AcgpFlag Property, Buffer Property, Cagp Property, CagpFlag Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Fctr Property, FctrFlag Property, hWnd Property, Name Property, NameFlag Property, Rfc Property, RfcFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
AccFail Object
The AccFail object provides access to the Access Failure Log table.
Properties
Accd Property, AccdFlag Property, Acfl Property, AcflFlag Property, Actm Property, ActmFlag Property, Apcd Property, ApcdFlag Property, Buffer Property, Code Property, CodeFlag Property, Count Property, CountRec Property, Cpu Property, CpuFlag Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Flag Property, FlagFlag Property, hWnd Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
AccGrp Object
The AccGroup object provides access to the Assignable Cause Code Group table.
Properties
Abbr Property, AbbrFlag Property, Acgp Property, AcgpFlag Property, Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Fctr Property, FctrFlag Property, hWnd Property, Name Property, NameFlag Property, Rfc Property, RfcFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
AccLink Object
The AccLink object provides access to the Assignable Cause Code Linkage table.
Properties
Acgp Property, AcgpFlag Property, Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Flag Property, FlagFlag Property, hWnd Property, Link Property, LinkFlag Property, Part Property, PartFlag Property, Prcs Property, PrcsFlag Property, Prgp Property, PrgpFlag Property, Ptgp Property, PtgpFlag Property, Rfc Property, RfcFlag Property, Test Property, TestFlag Property, Tsgp Property, TsgpFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
AccLinkV Object
The AccLinkV object provides access to the Assignable Cause Code Linkage view.
Properties
Abbr Property, AbbrFlag Property, Acgp Property, AcgpFlag Property, Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Fctr Property, FctrFlag Property, hWnd Property, Link Property, LinkFlag Property, Name Property, NameFlag Property, Part Property, PartFlag Property, Prcs Property, PrcsFlag Property, Prgp Property, PrgpFlag Property, Ptgp Property, PtgpFlag Property, Rfc Property, RfcFlag Property, Test Property, TestFlag Property, Text Property, TextFlag Property, Tsgp Property, TsgpFlag Property, User Property (Long), UserFlag Property
Methods
AddRec Statement, Clear Statement, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
AccLog Object
The AccLog object provides access to the Access Log table.
Properties
Accd Property, AccdFlag Property, Aclg Property, AclgFlag Property, Actm Property, ActmFlag Property, Apcd Property, ApcdFlag Property, Buffer Property, Count Property, CountRec Property, Cpu Property, CpuFlag Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, hWnd Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
AlrRule Object
The AlrRule object provides access to the Alarm Rules Assignments table.
Properties
Alr Property, AlrmFlag Property, Alrm Property, AlrmFlag Property, Buffer Property, Chrt Property, ChrtFlag Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, hWnd Property, Prcs Property, PrcsFlag Property, Rfc Property, RfcFlag Property, Test Property, TestFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
AreaInf Object
The AreaInf object provides access to the Area Information table.
Properties
Abbr Property, AbbrFlag Property, Area Property, AreaFlag Property, Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dept Property, DeptFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Fctr Property, FctrFlag Property, hWnd Property, Name Property, NameFlag Property, Rfc Property, RfcFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
Buffer Object
The Buffer object can be used to maintain a collection of names and associated numeric values. Various InfinityQS applications use this object to improve database performance by reducing queries. Consider an import scenario, for example, with a data file of 100 records that includes only 10 different part "names" randomly scattered throughout the file. During the import process, the Part Table must be queried to obtain their IDs. But rather than invoking the Find for all 100 records, it would be far more efficient to query only 10 times, for each unique part.
The following code snippet demonstrates the above scenario. The function takes in a Part Name and attempts to obtain its ID from a Buffer object. If the name is not found in the buffer, the database is queried and the returned Part ID and Name are then added to the Buffer.
Public Function GetPartID(ByVal Name As String) As Long
Dim lngPart As Long
If moPartBuffer Is Nothing Then
'Create a Part Buffer
Set moPartBuffer = New iiaDatabase6.Buffer
Else
'Get the Part ID from the Part Buffer
lngPart = moPartBuffer.ID(Name)
End If
If lngPart = 0 Then
'Part is not buffered yet, so query the database
lngPart = GetPart(Name)
If lngPart <> 0 Then
'Add queried Part to the buffer
moPartBuffer.AddItem Name, lngPart
End If
End If
GetPartID = lngPart
End Function
Properties
Methods
AddItem Statement, Clear Statement, ExtID Function (Buffer Object), ID Function (Buffer Object), IDExists Function (Buffer Object), Name Property
CacDat Object
The CacDat object provides access to the Corrective Action Codes table.
Properties
Abbr Property, AbbrFlag Property, Buffer Property, Cac Property, CacFlag Property, Cagp Property, CagpFlag Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Fctr Property, FctrFlag Property, hWnd Property, Name Property, NameFlag Property, Rfc Property, RfcFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
CacGrp Object
The CacGrp object provides access to the Corrective Action Code Group table.
Properties
Abbr Property, AbbrFlag Property, Buffer Property, Cagp Property, CagpFlag Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Fctr Property, FctrFlag Property, hWnd Property, Name Property, NameFlag Property, Rfc Property, RfcFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
CalCmt Object
The CalCmt object provides access to the Calibration Comments. Calibration Comments are typically used in conjunction with the CalDat and CalInf objects.
Properties
Buffer Property, Clid Property, ClidFlag Property, Count Property, CountRec Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, hWnd Property, Line Property, LineFlag Property, Rfc Property, RfcFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
CalDat Object
The CalDat object provides access to the Calibration Data. Calibration Data is typically used in conjunction with the CalInf object.
Properties
Buffer Property, Clid Property, ClidFlag Property, Clno Property, ClnoFlag Property, Count Property, CountRec Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Finl Property, FinlFlag Property, Gage Property, GageFlag Property, hWnd Property, Init Property, InitFlag Property, Mtol Property, Name Property, Mtyp Property, MtypFlag Property, Ptol Property, PtolFlag Property, Rfc Property, RfcFlag Property, Rfno Property, RfnoFlag Property, Rval Property, RvalFlag Property, Stat Property, StatFlag Property, Tval Property, TvalFlag Property, User Property (Long), UserFlag Property, Utyp Property, UtypFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
CalInf Object
The CalInf object provides access to the Calibration Information table.
Properties
Bar Property, BarFlag Property, Buffer Property, Clid Property, ClidFlag Property, Cltm Property, CltmFlag Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Eltm Property, EltmFlag Property, Empl Property (ID), EmplFlag Property, Gage Property, GageFlag Property, Hmdy Property, HmdyFlag Property, hWnd Property, JobOpPrcs Object, LabFlag Property, Rfc Property, RfcFlag Property, Stat Property, StatFlag Property, Stkr Property, StkrFlag Property, Temp Property, TempFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
CoInf Object
The CoInf object provides access to the Company Information table.
Properties
Abbr Property, AbbrFlag Property, Buffer Property, Co Property, CoFlag Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Fctr Property, FctrFlag Property, hWnd Property, Name Property, NameFlag Property, Rfc Property, RfcFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
CtrlLim Object
The CtrlLim object provides access to the Control Limits table.
Properties
Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Ctrl Property, CtrlFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Eftm Property, EftmFlag Property, Fctr Property, FctrFlag Property, Fntm Property, FntmFlag Property, hWnd Property, Mean Property, MeanFlag Property, Part Property, PartFlag Property, Prcs Property, PrcsFlag Property, Rfc Property, RfcFlag Property, Sp Property, SpFlag Property, Spl Property, SplFlag Property, Sttm Property, SttmFlag Property, Sw Property, SwFlag Property, Swl Property, SwlFlag Property, Test Property, TestFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
CtrlSgrp Object
The CtrlSgrp object provides access to the Control Limit Subgroups table.
Properties
Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Ctrl Property, CtrlFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, hWnd Property, Rfc Property, RfcFlag Property, Sgrp Property, SgrpFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
Database Object
The Database object provides the physical connection to an InfinityQS Database. Other objects requiring a database connection will need to be provided a reference to a "connected" Database object.
Before a Database object can be used, it must be authenticated. Typically, Authenticate should be provided a handle to the active window. However, if there is no window, a value of 0 is acceptable.
For guidance getting started with the Database object, see Using the Database Object.
Properties
DatabaseInformation Object, DSN Property, DSNDefinition Property, hWndOwner Property, IsConnected Property, Password Property, Reconnect Property, Task Property, UserName Property
Methods
About Statement, Authenticate Function, Connect Function, ConnectedEmployee Function, Disconnect Function, HasPrivilege Function, PostErrors Function
Events
Connected Event, Disconnected Event
DatabaseInformation Object
The DatabaseInformation object is reserved for Internal Use Only.
Properties
DSN Property, Password Property, Pwd Property, UID Property, User Property (Long)
Methods
GetData Function, SetData Statement
DatabaseManager Object
The DatabaseManager object is reserved for Internal Use Only.
Methods
AccessCode Function, BuildOrder Function, ClearTables Function, CreateDefaultAlarmRules Function, CreateIndexes Function, CreateTables Function, DropIndexes Function, DropTables Function, GetFieldDefinition Function, GetTableDefinition Function, InitializeEventTables Function, InitializeSubgroupTables Function, LoadTable Function
DbInf Object
The DbInf object provides access to the Database Information table. It is reserved for Internal Use Only.
Properties
Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, hWnd Property, Id Property, IdFlag Property, Rfc Property, RfcFlag Property, Str1 Property, Str1Flag Property, Str2 Property, Str2Flag Property, Typ Property, TypFlag Property, User Property (Long), UserFlag Property, Var1 Property, Var1Flag Property, Var2 Property, Var2Flag Property, Var3 Property, Var3Flag Property, Var4 Property, Var4Flag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
DefDat Object
The DefDat object provides access to the Defect/Defective Code table.
Properties
Abbr Property, AbbrFlag Property, Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Def Property, DefFlag Property, Dfgp Property, DfgpFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Fctr Property, FctrFlag Property, hWnd Property, Name Property, NameFlag Property, Rfc Property, RfcFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property, Val Property, ValFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
DefGrp Object
The DefGrp object provides access to the Defect/Defective Group table.
Properties
Abbr Property, AbbrFlag Property, Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dfgp Property, DfgpFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Fctr Property, FctrFlag Property, hWnd Property, Name Property, NameFlag Property, Rfc Property, RfcFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
DefOpp Object
The DefOpp object provides access to the Defect Opportunities table.
Properties
Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dfop Property, DfopFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, hWnd Property, Opps Property, OppsFlag Property, Part Property, PartFlag Property, Rfc Property, RfcFlag Property, Test Property, TestFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
DeptInf Object
The DeptInf object provides access to the Department Information table.
Properties
Abbr Property, AbbrFlag Property, Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dept Property, DeptFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Fctr Property, FctrFlag Property, hWnd Property, Name Property, NameFlag Property, Rfc Property, RfcFlag Property, Site Property, SiteFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
DescDat Object
The DescDat object provides access to the Descriptor table.
Properties
Abbr Property, AbbrFlag Property, Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Desc Property, DescFlag Property, Dsbl Property, DsblFlag Property, Dsgp Property, DsgpFlag Property, Edtm Property, EdtmFlag Property, Fctr Property, FctrFlag Property, hWnd Property, Name Property, NameFlag Property, Rfc Property, RfcFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
DescGrp Object
The DescGrp object provides access to the Descriptor Group table.
Properties
Abbr Property, AbbrFlag Property, Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Dsgp Property, DsgpFlag Property, Edtm Property, EdtmFlag Property, Fctr Property, FctrFlag Property, hWnd Property, Name Property, NameFlag Property, Rfc Property, RfcFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
DivInf Object
The DivInf object provdes access to Division Information records.
Properties
Abbr Property, AbbrFlag Property, Buffer Property, Co Property, CoFlag Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Div Property, DivFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Fctr Property, FctrFlag Property, hWnd Property, Name Property, NameFlag Property, Rfc Property, RfcFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
EmplInf Object
The EmplInf object provides access to the Employee Information table.
Properties
Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dept Property, DeptFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Email Property, EmailFlag Property, Empl Property (ID), EmplFlag Property, Epid Property, EpidFlag Property, Fctr Property, FctrFlag Property, hWnd Property, Name Property, NameFlag Property, Rfc Property, RfcFlag Property, Stat Property, StatFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
EmplPch Object
The EmplPch object provides access to the Employee Password History table. It is reserved for Internal Use Only.
Properties
Buffer Property, Chtm Property, ChtmFlag Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Empl Property (ID), EmplFlag Property, hWnd Property, Pwd Property, PwdFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
EmplSec Object
The EmplSec object provides access to the Employee Security table. It is reserved for Internal Use Only.
Properties
Actm Property, ActmFlag Property, Buffer Property, Chtm Property, ChtmFlag Property, Code Property, CodeFlag Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Empl Property (ID), EmplFlag Property, hWnd Property, Locked Property, LockedFlag Property, Pwd Property, PwdFlag Property, Rfc Property, RfcFlag Property, Rtry Property, RtryFlag Property, Rttm Property, RttmFlag Property, Secu Property, SecuFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
EmplXtr Object
The EmplXtr object provides access to the Employee Extra table. It is reserved for Internal Use Only.
Properties
Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Empl Property (ID), EmplFlag Property, hWnd Property, Rfc Property, RfcFlag Property, Str1 Property, Str1Flag Property, Str2 Property, Str2Flag Property, Typ Property, TypFlag Property, User Property (Long), UserFlag Property, Var1 Property, Var1Flag Property, Var2 Property, Var2Flag Property, Var3 Property, Var3Flag Property, Var4 Property, Var4Flag Property, Xtra Property, XtraFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
EvntCmt Object
The EvntCmt object provides access to the Event Comment table. This object is typically used in conjunction with the EvntInf object.
Properties
Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Empl Property (Name), EmplFlag Property, Evnt Property, EvntFlag Property, hWnd Property, Note Property, NoteFlag Property, Rfc Property, RfcFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
EvntInf Object
The EvntInf object provides access to the Event Information table.
Properties
Acc Property, AccFlag Property, Acem Property, AcemFlag Property, Actm Property, ActmFlag Property, Buffer Property, Cac Property, CacFlag Property, Caem Property, CaemFlag Property, Catm Property, CatmFlag Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Empl Property (ID), EmplFlag Property, Evnt Property, EvntFlag Property, Evtm Property, EvtmFlag Property, Flag Property, FlagFlag Property, hWnd Property, Name Property, NameFlag Property, Part Property, PartFlag Property, Prcs Property, PrcsFlag Property, Rfc Property, RfcFlag Property, Sgtm Property, SgtmFlag Property, Test Property, TestFlag Property, Typ Property, TypFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
FieldDefinition Object
The FieldDefinitions object is for Internal Use Only.
Properties
Description Property, FieldType Property, ForeignKey Property, IsTimeField Property, Length Property, Name Property, PrimaryKey Property, ReferenceField Property, ReferenceKey Property, ReferenceTable Property, Unique Property
GageInf Object
The GageInf object provides access to the Gage Information table.
Properties
Actv Property, ActvFlag Property, Aqtm Property, AqtmFlag Property, Buffer Property, Clby Property, ClbyFlag Property, Cltm Property, CltmFlag Property, Cost Property, CostFlag Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Cust Property, CustFlag Property, Cyca Property, CycaFlag Property, Cycx Property, CycxFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Gage Property, GageFlag Property, Gid Property, GidFlag Property, Gmdl Property, GmdlFlag Property, Gsn Property, GsnFlag Property, Gtyp Property, GtypFlag Property, hWnd Property, Mfgr Property, MfgrFlag Property, Mstr Property, MstrFlag Property, Mvtm Property, MvtmFlag Property, Prut Property, PrutFlag Property, Rfc Property, RfcFlag Property, Rntm Property, RntmFlag Property, Rttm Property, RttmFlag Property, Stat Property, StatFlag Property, User Property (Long), UserFlag Property, Vndr Property, VndrFlag Property, Xcal Property, XcalFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
GageLoc Object
The GageLoc object provides access to the Gage Location view.
Properties
Actv Property, ActvFlag Property, Aqtm Property, AqtmFlag Property, Buffer Property, Clby Property, ClbyFlag Property, Cltm Property, CltmFlag Property, Cost Property, CostFlag Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Cust Property, CustFlag Property, Cyca Property, CycaFlag Property, Cycx Property, CycxFlag Property, Dsbl Property, DsblFlag Property, Due Property, DueFlag Property, Edtm Property, EdtmFlag Property, Empl Property (ID), EmplFlag Property, Gage Property, GageFlag Property, Gid Property, GidFlag Property, Gmdl Property, GmdlFlag Property, Gsn Property, GsnFlag Property, Gtyp Property, GtypFlag Property, hWnd Property, Mfgr Property, MfgrFlag Property, Mstr Property, MstrFlag Property, Mvtm Property, MvtmFlag Property, Prut Property, PrutFlag Property, Rfc Property, RfcFlag Property, Rntm Property, RntmFlag Property, Rttm Property, RttmFlag Property, User Property (Long), UserFlag Property, Vndr Property, VndrFlag Property, Xcal Property, XcalFlag Property
Methods
AddRec Statement, Clear Statement, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
GageMdl Object
The GageMdl object provides access to the Gage Model table.
Properties
Accu Property, AccuFlag Property, Buffer Property, Cost Property, CostFlag Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Cyca Property, CycaFlag Property, Cycx Property, CycxFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Fixed Property, FixedFlag Property, Gmdl Property, GmdlFlag Property, Gtyp Property, GtypFlag Property, hWnd Property, JobOpPrcs Object, LabFlag Property, Lrl Property, LrlFlag Property, Mdl Property, MdlFlag Property, Mfgr Property, MfgrFlag Property, Nom Property, NomFlag Property, Prcd Property, PrcdFlag Property, Requ Property, RequFlag Property, Res Property (Long), ResFlag Property, Rfc Property, RfcFlag Property, Stat Property, StatFlag Property, Url Property, UrlFlag Property, User Property (Long), UserFlag Property, Utyp Property, UtypFlag Property, Vndr Property, VndrFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
GageMov Object
The GageMov object provides access to the Gage Movement History table.
Properties
Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Due Property, DueFlag Property, Edtm Property, EdtmFlag Property, Empl Property (ID), EmplFlag Property, Gage Property, GageFlag Property, Gmid Property, GmidFlag Property, hWnd Property, Mvtm Property, MvtmFlag Property, Note Property, NoteFlag Property, Prut Property, PrutFlag Property, Rfc Property, RfcFlag Property, Stat Property, StatFlag Property, User Property (Long), UserFlag Property, Wkno Property, WknoFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
GageRef Object
The GageRef object provides access to the Gage Reference table.
Properties
Buffer Property, Count Property, CountRec Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Gage Property, GageFlag Property, Grsn Property, GrsnFlag Property, hWnd Property, Name Property, NameFlag Property, Rfc Property, RfcFlag Property, Rfno Property, RfnoFlag Property, Rval Property, RvalFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
GageTyp Object
The GageTyp object provides access to the Gage Type table.
Properties
Abbr Property, AbbrFlag Property, Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Fctr Property, FctrFlag Property, Gtyp Property, GtypFlag Property, hWnd Property, Name Property, NameFlag Property, Rfc Property, RfcFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
GmdlRef Object
The GmdlRef object provides access to the Gage Model Reference table.
Properties
Buffer Property, Count Property, CountRec Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Gmdl Property, GmdlFlag Property, hWnd Property, Name Property, NameFlag Property, Rfc Property, RfcFlag Property, Rfno Property, RfnoFlag Property, Rval Property, RvalFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
GrrCmt Object
The GrrCmt object provides access to the Gage Study Comments table. Typically, it is used in conjunction with the GrrInf and GrrDat objects.
Properties
Buffer Property, Count Property, CountRec Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Gsid Property, GsidFlag Property, hWnd Property, Line Property, LineFlag Property, Rfc Property, RfcFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
GrrDat Object
The GrrDat object provides access to the Gage Study Data table.
Properties
Buffer Property, Count Property, CountRec Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Flag Property, FlagFlag Property, Gsid Property, GsidFlag Property, hWnd Property, Oper Property, OperFlag Property, Rfc Property, RfcFlag Property, Sgrp Property, SgrpFlag Property, Trial Property, TrialFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
GrrExt Object
The GrrExt object provides access to the Gage Study Data view.
Properties
Av Property, AvFlag Property, Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Ev Property, EvFlag Property, Fctr Property, FctrFlag Property, Fntm Property, FntmFlag Property, Gage Property, GageFlag Property, Gmdl Property, GmdlFlag Property, Grr Property, GrrFlag Property, Gsid Property, GsidFlag Property, Gtyp Property, GtypFlag Property, hWnd Property, Mtyp Property, MtypFlag Property, Name Property, NameFlag Property, Part Property, PartFlag Property, Prcs Property, PrcsFlag Property, Pv Property, PvFlag Property, Rfc Property, RfcFlag Property, Stat Property, StatFlag Property, Sttm Property, SttmFlag Property, Test Property, TestFlag Property, Tv Property, TvFlag Property, User Property (Long), UserFlag Property, Utyp Property, UtypFlag Property, Wiv Property, WivFlag Property
Methods
AddRec Statement, Clear Statement, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
GrrInf Object
The GrrInf object provides access to the Gage Study Information table.
Properties
Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Fntm Property, FntmFlag Property, Gsid Property, GsidFlag Property, hWnd Property, Name Property, NameFlag Property, Oper Property, OperFlag Property, Rfc Property, RfcFlag Property, Stat Property, StatFlag Property, Sttm Property, SttmFlag Property, Trial Property, TrialFlag Property, Tsno Property, TsnoFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
GrrSum Object
The GrrSum object provides access to the Gage Study Summary table.
Properties
Av Property, AvFlag Property, Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Ev Property, EvFlag Property, Fctr Property, FctrFlag Property, Fntm Property, FntmFlag Property, Gage Property, GageFlag Property, Gmdl Property, GmdlFlag Property, Grr Property, GrrFlag Property, Gsid Property, GsidFlag Property, Gtyp Property, GtypFlag Property, hWnd Property, Mtyp Property, MtypFlag Property, Part Property, PartFlag Property, Prcs Property, PrcsFlag Property, Pv Property, PvFlag Property, Rfc Property, RfcFlag Property, Test Property, TestFlag Property, Tv Property, TvFlag Property, User Property (Long), UserFlag Property, Utyp Property, UtypFlag Property, Wiv Property, WivFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
JobDat Object
The JobDat object provides access to the Job table.
Properties
Abbr Property, AbbrFlag Property, Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Fctr Property, FctrFlag Property, Fntm Property, FntmFlag Property, Hold Property, HoldFlag Property, hWnd Property, Jbgp Property, JbgpFlag Property, Job Property, JobFlag Property, Name Property, NameFlag Property, Rfc Property, RfcFlag Property, Site Property, SiteFlag Property, Stat Property, StatFlag Property, Sttm Property, SttmFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
JobDsc Object
The JobDsc object provides access to the Job Descriptors table.
Properties
Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Desc Property, DescFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, hWnd Property, Jbds Property, JbdsFlag Property, Job Property, JobFlag Property, Rfc Property, RfcFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
JobGrp Object
The JobGrp object provides access to the Job Group table.
Properties
Abbr Property, AbbrFlag Property, Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Fctr Property, FctrFlag Property, hWnd Property, Jbgp Property, JbgpFlag Property, Name Property, NameFlag Property, Rfc Property, RfcFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
JobOp Object
The JobOp object provides access to the Job Operation table. It identifies the operations of a Job.
Properties
Abbr Property, AbbrFlag Property, Buffer Property, Closed Property, ClosedFlag Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, hWnd Property, Jbop Property, JbopFlag Property, Job Property, JobFlag Property, Name Property, NameFlag Property, Opened Property, OpenedFlag Property, Opno Property, OpnoFlag Property, Part Property, PartFlag Property, Rfc Property, RfcFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
JobOpDsc Object
Properties
Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Desc Property, DescFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, hWnd Property, Jbop Property, JbopFlag Property, Jods Property, JodsFlag Property, Rfc Property, RfcFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
JobOpLot Object
The JobOpLot object provides access to the Job-Lot table. The Job-Lot table associates Lot Information with Job Operations.
Properties
Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, hWnd Property, Jolt Property, JoltFlag Property, Jbop Property, JbopFlag Property, Lot Property, LotFlag Property, Rfc Property, RfcFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
JobOpPrcs Object
The JobOpPrcs object provides access to the Job-Process table. The Job-Process table associates Process Information with Job Operations.
Properties
Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, hWnd Property, Jbop Property, JbopFlag Property, Jopr Property, JoprFlag Property, Prcs Property, PrcsFlag Property, Rfc Property, RfcFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
JobSum Object
The JobSum object provides access to the Job Summary table.
Properties
Buffer Property, Cnt Property, CntFlag Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Eflag Property, EflagFlag Property, Evct Property, EvctFlag Property, Fntm Property, FntmFlag Property, hWnd Property, Jbsm Property, JbsmFlag Property, Job Property, JobFlag Property, Lrl Property, LrlFlag Property, Lsl Property, LslFlag Property, Max Property, MaxFlag Property, Mean Property, MeanFlag Property, Min Property, MinFlag Property, Oor Property, OorFlag Property, Oos Property, OosFlag Property, Part Property, PartFlag Property, Pp Property, PpFlag Property, Ppk Property, PpkFlag Property, Rfc Property, RfcFlag Property, Size Property (Long), Size Property (Long), Sp Property, SpFlag Property, Sttm Property, SttmFlag Property, Tar Property, TarFlag Property, Test Property, TestFlag Property, Url Property, UrlFlag Property, User Property (Long), UserFlag Property, Usl Property, UslFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
LngDat Object
The LngDat object provides access to the Language Resource table.
Properties
Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, hWnd Property, Line Property, LineFlag Property, Lng Property, LngFlag Property, Res Property (Long), ResFlag Property, Rfc Property, RfcFlag Property, Rfno Property, RfnoFlag Property, Sect Property, SectFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
LngTyp Object
The LngTyp object provides access to the Language Type table.
Properties
Abbr Property, AbbrFlag Property, Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, hWnd Property, Lng Property, LngFlag Property, Name Property, NameFlag Property, Rfc Property, RfcFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
LotAcReq Object
Properties
Alpha Property, AlphaFlag Property, Aql Property, AqlFlag Property, Beta Property, BetaFlag Property, Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Eftm Property, EftmFlag Property, hWnd Property, Lasr Property, LasrFlag Property, Ltpd Property, LtpdFlag Property, Opt Property, OptFlag Property, Part Property, PartFlag Property, Prcs Property, PrcsFlag Property, Rfc Property, RfcFlag Property, Sd_Spec Property, Sd_SpecFlag Property, Test Property, TestFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
LotAcSum Object
Properties
Alpha Property, AlphaFlag Property, Aql Property, AqlFlag Property, Beta Property, BetaFlag Property, Buffer Property, Cnt Property, CntFlag Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Eflag Property, EflagFlag Property, Fntm Property, FntmFlag Property, hWnd Property, Lass Property, LassFlag Property, Lot Property, LotFlag Property, Lsl Property, LslFlag Property, Ltpd Property, LtpdFlag Property, Max Property, MaxFlag Property, Mean Property, MeanFlag Property, Min Property, MinFlag Property, Opt Property, OptFlag Property, Part Property, PartFlag Property, Pdef Property, PdefFlag Property, Prcs Property, PrcsFlag Property, Rej Property, RejFlag Property, Rfc Property, RfcFlag Property, Rtest Property, RtestFlag Property, Sd_Act Property, Sd_ActFlag Property, Sd_Spec Property, Sd_SpecFlag Property, Size Property (Long), Size Property (Long), Stat Property, StatFlag Property, Sttm Property, SttmFlag Property, Tar Property, TarFlag Property, Test Property, TestFlag Property, User Property (Long), UserFlag Property, Usl Property, UslFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
LotSum Object
Properties
The LotSum object provides access to the Lot Summary table.
Buffer Property, Cnt Property, CntFlag Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Eflag Property, EflagFlag Property, Evct Property, EvctFlag Property, Fntm Property, FntmFlag Property, hWnd Property, Lot Property, LotFlag Property, Lrl Property, LrlFlag Property, Lsl Property, LslFlag Property, Ltsm Property, LtsmFlag Property, Max Property, MaxFlag Property, Mean Property, MeanFlag Property, Min Property, MinFlag Property, Oor Property, OorFlag Property, Oos Property, OosFlag Property, Pp Property, PpFlag Property, Ppk Property, PpkFlag Property, Rfc Property, RfcFlag Property, Sp Property, SpFlag Property, Sttm Property, SttmFlag Property, Tar Property, TarFlag Property, Test Property, TestFlag Property, Url Property, UrlFlag Property, User Property (Long), UserFlag Property, Usl Property, UslFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
MeasTyp Object
The MeasTyp object provides access to the Measurement Type table.
Properties
Abbr Property, AbbrFlag Property, Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Fctr Property, FctrFlag Property, hWnd Property, Mtyp Property, MtypFlag Property, Name Property, NameFlag Property, Rfc Property, RfcFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
NetInf Object
Properties
Abbr Property, AbbrFlag Property, Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Fctr Property, FctrFlag Property, hWnd Property, Name Property, NameFlag Property, Net Property, NetFlag Property, Rfc Property, RfcFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
PartDat Object
The PartDat object provides access to the Part table.
Properties
Abbr Property, AbbrFlag Property, Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Div Property, DivFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Fctr Property, FctrFlag Property, hWnd Property, Name Property, NameFlag Property, Part Property, PartFlag Property, Ptgp Property, PtgpFlag Property, Rfc Property, RfcFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
PartGrp Object
The PartGrp object provides access to the Part Group table.
Properties
Abbr Property, AbbrFlag Property, Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Fctr Property, FctrFlag Property, hWnd Property, Name Property, NameFlag Property, Ptgp Property, PtgpFlag Property, Rfc Property, RfcFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
PartLot Object
The PartLot object provides access to the Lot table.
Properties
Abbr Property, AbbrFlag Property, Buffer Property, Ccpnt Property, CcpntFlag Property, Closed Property, ClosedFlag Property, Cost Property, CostFlag Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Ctest Property, CtestFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Fctr Property, FctrFlag Property, Hold Property, HoldFlag Property, hWnd Property, Lot Property, LotFlag Property, Name Property, NameFlag Property, Part Property, PartFlag Property, Prcs Property, PrcsFlag Property, Rcpnt Property, RcpntFlag Property, Rfc Property, RfcFlag Property, Rtest Property, RtestFlag Property, Size Property (Long), SizeFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
PartRev Object
Properties
Abbr Property, AbbrFlag Property, Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Fctr Property, FctrFlag Property, Fntm Property, FntmFlag Property, hWnd Property, Name Property, NameFlag Property, Part Property, PartFlag Property, Ptrv Property, PtrvFlag Property, Rfc Property, RfcFlag Property, Sttm Property, SttmFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
PartSn Object
The PartSn object provides access to the Part Serial Number table.
Properties
Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Flag Property, FlagFlag Property, hWnd Property, Name Property, NameFlag Property, Part Property, PartFlag Property, Rfc Property, RfcFlag Property, Sn Property, SnFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
PartTest Object
Properties
Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, hWnd Property, Id Property, IdFlag Property, Index Property, IndexFlag Property, Part Property, PartFlag Property, Rfc Property, RfcFlag Property, Str1 Property, Str1Flag Property, Str2 Property, Str2Flag Property, Test Property, TestFlag Property, Typ Property, TypFlag Property, User Property (Long), UserFlag Property, Var1 Property, Var1Flag Property, Var2 Property, Var2Flag Property, Var3 Property, Var3Flag Property, Var4 Property, Var4Flag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
PrcdDat Object
The PrcdDat object provides access to the Procedure Data table.
Properties
Buffer Property, Count Property, CountRec Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, hWnd Property, Line Property, LineFlag Property, Prcd Property, PrcdFlag Property, Rfc Property, RfcFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
PrcdInf Object
The PrcdInf object provides access to the Procedure Information table.
Properties
Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Empl Property (ID), EmplFlag Property, hWnd Property, Name Property, NameFlag Property, Note Property, NoteFlag Property, Prcd Property, PrcdFlag Property, Rfc Property, RfcFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
PrcsDat Object
The PrcsDat object provides access to the Process table.
Properties
Abbr Property, AbbrFlag Property, Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Fctr Property, FctrFlag Property, hWnd Property, Name Property, NameFlag Property, Prcs Property, PrcsFlag Property, Prgp Property, PrgpFlag Property, Prut Property, PrutFlag Property, Rfc Property, RfcFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
PrcsGrp Object
The PrcsGrp object provides access to the Process Group table.
Properties
Abbr Property, AbbrFlag Property, Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Fctr Property, FctrFlag Property, hWnd Property, Name Property, NameFlag Property, Prgp Property, PrgpFlag Property, Rfc Property, RfcFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
PrcsUnt Object
Properties
Abbr Property, AbbrFlag Property, Area Property, AreaFlag Property, Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Fctr Property, FctrFlag Property, hWnd Property, Name Property, NameFlag Property, Prut Property, PrutFlag Property, Rfc Property, RfcFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
RequDat Object
The RequDat object provides access to the Requirement Data table.
Properties
Buffer Property, Clno Property, ClnoFlag Property, Count Property, CountRec Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Gtyp Property, GtypFlag Property, hWnd Property, Mtol Property, Name Property, Mtyp Property, MtypFlag Property, Ptol Property, PtolFlag Property, Requ Property, RequFlag Property, Rfc Property, RfcFlag Property, Rval Property, RvalFlag Property, Tval Property, TvalFlag Property, User Property (Long), UserFlag Property, Utyp Property, UtypFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
RequInf Object
The RequInf object provides access to the Requirement Information table.
Properties
Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Empl Property (ID), EmplFlag Property, hWnd Property, Name Property, NameFlag Property, Note Property, NoteFlag Property, Requ Property, RequFlag Property, Rfc Property, RfcFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
RfcCode Object
The RfcCode object provides access to the Reason for Change Code table.
Properties
Abbr Property, AbbrFlag Property, Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Fctr Property, FctrFlag Property, hWnd Property, Name Property, NameFlag Property, Rfc Property, RfcFlag Property, Rscd Property, RscdFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
RfcInf Object
The RfcInf object provides access to the Reason for Change table.
Properties
Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, hWnd Property, Note Property, NoteFlag Property, Rfc Property, RfcFlag Property, Rscd Property, RscdFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
RuleDef Object
The RuleDef object provides access to the Alarm Rule Definitions table.
Properties
Buffer Property, Cnt Property, CntFlag Property, Code Property, CodeFlag Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Hits Property, HitsFlag Property, hWnd Property, Name Property, NameFlag Property, Prty Property, PrtyFlag Property, Rfc Property, RfcFlag Property, Rule Property, RuleFlag Property, Typ Property, TypFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
SecuInf Object
The SecuInf object provides access to the Role Information table.
Properties
Aclv Property, AclvFlag Property, Admn Property, AdmnFlag Property, Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, GtsApp Property, GtsAppFlag Property, hWnd Property, MsaApp Property, MsaAppFlag Property, Name Property, NameFlag Property, Rfc Property, RfcFlag Property, Secu Property, SecuFlag Property, SpcApp Property, SpcAppFlag Property, Sys Property, SysFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
SecuXtr Object
The SecuXtr object provides access to the Role Extra table.
Properties
Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, hWnd Property, Rfc Property, RfcFlag Property, Secu Property, SecuFlag Property, Str1 Property, Str1Flag Property, Str2 Property, Str2Flag Property, Typ Property, TypFlag Property, User Property (Long), UserFlag Property, Var1 Property, Var1Flag Property, Var2 Property, Var2Flag Property, Var3 Property, Var3Flag Property, Var4 Property, Var4Flag Property, Xtra Property, XtraFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
SgrpCmt Object
The SgrpCmt object provides access to the Subgroup Comments table.
Properties
Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Empl Property (Name), EmplFlag Property, hWnd Property, Note Property, NoteFlag Property, Rfc Property, RfcFlag Property, Sgrp Property, SgrpFlag Property, Test Property, TestFlag Property, Tsno Property, TsnoFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
SgrpDsc Object
The SgrpDsc object provides access to the Subgroup Descriptors table.
Properties
Buffer Property, Count Property, CountRec Property, Desc Property, DescFlag Property, Dsbl Property, DsblFlag Property, Dsgp Property, DsgpFlag Property, Edtm Property, EdtmFlag Property, hWnd Property, Rfc Property, RfcFlag Property, Sgrp Property, SgrpFlag Property, Tsno Property, TsnoFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
SgrpExt Object
The SgrpExt object provides access to the Subgroup Data view.
Properties
Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Def Property, DefFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Empl Property (ID), EmplFlag Property, Flag Property, FlagFlag Property, Gage Property, GageFlag Property, hWnd Property, Job Property, JobFlag Property, Lot Property, LotFlag Property, Part Property, PartFlag Property, Prcs Property, PrcsFlag Property, Rfc Property, RfcFlag Property, Sbno Property, SbnoFlag Property, Sgrp Property, SgrpFlag Property, Sgsz Property, SgszFlag Property, Sgtm Property, SgtmFlag Property, Sn Property, SnFlag Property, Splt Property, SpltFlag Property, Test Property, TestFlag Property, Tsno Property, TsnoFlag Property, User Property (Long), UserFlag Property, Val Property, ValFlag Property, Wkno Property, WknoFlag Property
Methods
AddRec Statement, Clear Statement, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
SgrpInf Object
The SgrpInf object provides access to the Subgroup Information table.
Properties
Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Empl Property (ID), EmplFlag Property, Flag Property, FlagFlag Property, hWnd Property, Job Property, JobFlag Property, Lot Property, LotFlag Property, Part Property, PartFlag Property, Prcs Property, PrcsFlag Property, Ptrv Property, PtrvFlag Property, Rfc Property, RfcFlag Property, Sgrp Property, SgrpFlag Property, Sgsz Property, SgszFlag Property, Sgtm Property, SgtmFlag Property, Splt Property, SpltFlag Property, User Property (Long), UserFlag Property, Wkno Property, WknoFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
SgrpLot Object
The SgrpLot object provides access to the Subgroup Component Lots table.
Properties
Buffer Property, Clot Property, ClotFlag Property, Count Property, CountRec Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, hWnd Property, Part Property, PartFlag Property, Rfc Property, RfcFlag Property, Sgrp Property, SgrpFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
SgrpTst Object
The SgrpTst object provides access to the Subgroup Tests table.
Properties
Buffer Property, Count Property, CountRec Property, Def Property, DefFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Flag Property, FlagFlag Property, Gage Property, GageFlag Property, hWnd Property, Rfc Property, RfcFlag Property, Sbno Property, SbnoFlag Property, Sgrp Property, SgrpFlag Property, Sn Property, SnFlag Property, Test Property, TestFlag Property, Tsno Property, TsnoFlag Property, User Property (Long), UserFlag Property, Val Property, ValFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
ShftDat Object
The ShftDat object provides access to the Shift table.
Properties
Abbr Property, AbbrFlag Property, Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Fctr Property, FctrFlag Property, hWnd Property, Name Property, NameFlag Property, Rfc Property, RfcFlag Property, Shft Property, ShftFlag Property, Shgp Property, ShgpFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
ShftGrp Object
The ShftGrp object provides access to the Shift Group table.
Properties
Abbr Property, AbbrFlag Property, Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Fctr Property, FctrFlag Property, hWnd Property, Name Property, NameFlag Property, Rfc Property, RfcFlag Property, Shgp Property, ShgpFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
SiteInf Object
Properties
Abbr Property, AbbrFlag Property, Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Div Property, DivFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Fctr Property, FctrFlag Property, hWnd Property, Name Property, NameFlag Property, Rfc Property, RfcFlag Property, Site Property, SiteFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
SpcMail Object
The SpcMail object provides access to the SPC Email Notification table.
Properties
Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Empl Property (ID), EmplFlag Property, Flag Property, FlagFlag Property, hWnd Property, Mail Property, MailFlag Property, Part Property, PartFlag Property, Prcs Property, PrcsFlag Property, Prgp Property, PrgpFlag Property, Ptgp Property, PtgpFlag Property, Rfc Property, RfcFlag Property, Test Property, TestFlag Property, Tsgp Property, TsgpFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
SPCMailRecipient Object
Obtaining appropriate SPC Mail Recipients using the SpcMail Object table object requires multiple queries and a greater knowledge of the InfinityQS business logic. The SPCMailRecipient object provides a friendlier way of identifying which employees are responsible for a specific part, process and test.
The SPCMailRecipient object's Find method will return false under the following circumstances.
- Database object is not connected to a database
- PartID is invalid
- ProcessID is invalid
- TestID is invalid
- No mail recipients were qualified for the specified PartID, ProcessID and TestID.
If it returns True the EmplInf property can be used to obtain a list of all qualified employees.
The following code example builds a list employees qualified to receive email for a specific PartID, ProcessID and TestID.
Dim oSPCMailRecipients As New iiaDatabase6.SPCMailRecipient
oSPCMailRecipients.PartID = lngPartID
oSPCMailRecipients.ProcessID = lngProcessID
oSPCMailRecipients.TestID = lngTestID
If oSPCMailRecipients.Find(moDatabase) Then
Do
List1.AddItem oSPCMailRecipients.EmplInf.Name
Loop While oSPCMailRecipients.EmplInf.NextRec
End If
Properties
EmplInf Object, PartID Property, ProcessID Property, TestID Property
Methods
SpecLim Object
The SpecLim object provides access to the Specification Limits table.
Properties
Aflag Property, AflagFlag Property, Buffer Property, Count Property, CountRec Property, Cp Property, CpFlag Property, Cpk Property, CpkFlag Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Eflag Property , EflagFlag Property, Fctr Property, FctrFlag Property, FirstTableIndex Property, FitFlag Property, hWnd Property, Job Property, JobFlag Property, Lds Property, LdsFlag Property, Lgb Property, LgbFlag Property, Lot Property, LotFlag Property, Lrl Property, LrlFlag Property, Lsg Property, LsgFlag Property, Lsl Property, LslFlag Property, Lwp Property, LwpFlag Property, Part Property, PartFlag Property, Prcs Property, PrcsFlag Property, Rev Property, RevFlag Property, Rfc Property, RfcFlag Property, Rrmar Property, RrmarFlag Property, Rrmax Property, RrmaxFlag Property, Scal Property, ScalFlag Property, Spec Property, SpecFlag Property, Tar Property, TarFlag Property, Test Property, TestFlag Property, Text Property, TextFlag Property, Uds Property, UdsFlag Property, Ugb Property, UgbFlag Property, Url Property, UrlFlag Property, User Property (Long), UserFlag Property, Usg Property, UsgFlag Property, Usl Property, UslFlag Property, Uwp Property, UwpFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
TableDefinition Object
Not Supported.
Properties
Description Property, FieldCount Property, Name Property, View Property
TestDat Object
The TestDat object provides access to the Test/Features table.
Properties
Abbr Property, AbbrFlag Property, Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dfgp Property, DfgpFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Fctr Property, FctrFlag Property, hWnd Property, Mtyp Property, MtypFlag Property, Name Property, NameFlag Property, Rfc Property, RfcFlag Property, Test Property, TestFlag Property, Text Property, TextFlag Property, Tsgp Property, TsgpFlag Property, Typ Property, TypFlag Property, User Property (Long), UserFlag Property, Utyp Property, UtypFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
TestGrp Object
The TestGrp object provides access to the Test/Features Group table.
Properties
Abbr Property, AbbrFlag Property, Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Fctr Property, FctrFlag Property, hWnd Property, Name Property, NameFlag Property, Rfc Property, RfcFlag Property, Text Property, TextFlag Property, Tsgp Property, TsgpFlag Property, User Property (Long), UserFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
UnitTyp Object
The UnitTyp object provides access to the Unit Type table.
Properties
Abbr Property, AbbrFlag Property, Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Fctr Property, FctrFlag Property, hWnd Property, Name Property, NameFlag Property, Rfc Property, RfcFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property, Utyp Property, UtypFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
WkstInf Object
Properties
Abbr Property, AbbrFlag Property, Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, Fctr Property, FctrFlag Property, hWnd Property, Name Property, NameFlag Property, Net Property, NetFlag Property, Rfc Property, RfcFlag Property, Text Property, TextFlag Property, User Property (Long), UserFlag Property, Wkst Property, WkstFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
WkstXtr Object
Properties
Buffer Property, Count Property, CountRec Property, Crtm Property, CrtmFlag Property, Dsbl Property, DsblFlag Property, Edtm Property, EdtmFlag Property, hWnd Property, Rfc Property, RfcFlag Property, Str1 Property, Str1Flag Property, Str2 Property, Str2Flag Property, Typ Property, TypFlag Property, User Property (Long), UserFlag Property, Var1 Property, Var1Flag Property, Var2 Property, Var2Flag Property, Var3 Property, Var3Flag Property, Var4 Property, Var4Flag Property, Wkst Property, WkstFlag Property, Xtra Property, XtraFlag Property
Methods
Add Function, AddBuffer Function, AddRec Statement, Clear Statement, Delete Function, DeleteBuffer Function, Edit Function, FillList Function, Find Function (Table Objects), FirstRec Function, GotoRec Function, InitializeFlags Statement, LastRec Function, NextRec Function, PrevRec Function, UpdateRec Statement
Properties
Many of the properties listed in this section are used by multiple Objects.
Abbr Property
This property returns or sets the 8 character abbreviation field value.
Syntax
strValue = object.Abbr
object.Abbr = strValue
Return Value
String
Related Objects
AccDat Object, AccGrp Object, AccLinkV Object, AreaInf Object, CacDat Object, CacGrp Object, CoInf Object, DefDat Object, DefGrp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, GageTyp Object, JobDat Object, JobGrp Object, JobOp Object, LngTyp Object, MeasTyp Object, NetInf Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RfcCode Object, ShftDat Object, ShftGrp Object, SiteInf Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object
AbbrFlag Property
See Field Flag Properties.
Syntax
lngValue = object.AbbrFlag
object.AbbrFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
AccDat Object, AccGrp Object, AccLinkV Object, AreaInf Object, CacDat Object, CacGrp Object, CoInf Object, DefDat Object, DefGrp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, JobDat Object, JobGrp Object, JobOp Object, LngTyp Object, MeasTyp Object, NetInf Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RfcCode Object, ShftDat Object, ShftGrp Object, SiteInf Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object
Acc Property
This property returns or sets an Assignable Cause Code record ID.
Syntax
lngValue = object.Acc
object.Acc = lngValue
Return Value
Long
Related Objects
Accd Property
This property returns or sets an Access Code value.
Syntax
lngValue = object.Accd
object.Accd = lngValue
Return Value
Long
Related Objects
AccdFlag Property
See Field Flag Properties.
Syntax
lngValue = object.AccdFlag
object.AccdFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
AccFlag Property
See Field Flag Properties.
Syntax
lngValue = object.AccFlag
object.AccFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Accu Property
This property returns or sets Gage Model Accuracy.
Syntax
dblValue = object.Accu
object.Accu = dblValue
Return Value
Double
Related Objects
AccuFlag Property
See Field Flag Properties.
Syntax
lngValue = object.AccuFlag
object.AccuFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Acem Property
This property returns or sets the employee record ID assigned to the Assignable Cause Code (Acc) of the Event Information (EvntInf).
Syntax
lngValue = object.Acem
object.Acem = lngValue
Return Value
Long
Related Objects
AcemFlag Property
See Field Flag Properties.
Syntax
lngValue = object.AcemFlag
object.AcemFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Acfl Property
This property returns or sets the Access Failure record ID.
Syntax
lngValue = object.Acfl
object.Acfl = lngValue
Return Value
Long
Related Objects
AcflFlag Property
See Field Flag Properties.
Syntax
lngValue = object.AcflFlag
object.AcflFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Acgp Property
This property returns or sets the Assignable Cause Code Group record ID.
Syntax
lngValue = object.Acgp
object.Acgp = lngValue
Return Value
Long
Related Objects
AccDat Object, AccGrp Object, AccLink Object, AccLinkV Object
AcgpFlag Property
See Field Flag Properties.
Syntax
lngValue = object.AcgpFlag
object.AcgpFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
AccDat Object, AccGrp Object, AccLink Object, AccLinkV Object
Aclg Property
This property returns or sets the Access Log record ID.
Syntax
lngValue = object.Aclg
object.Aclg = lngValue
Return Value
Long
Related Objects
AclgFlag Property
See Field Flag Properties.
Syntax
lngValue = object.AclgFlag
object.AclgFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Aclv Property
Syntax
lngValue = object.Aclv
object.Aclv = lngValue
Return Value
Long
Related Objects
AclvFlag Property
Syntax
lngValue = object.AclvFlag
object.AclvFlag = lngValue
Return Value
SQLFlagConstants
Related Objects
Actm Property
This property returns or sets a time value. For AccFail Object, AccLog Object, and EmplSec Object, Actm represents the user's Access Time. For EvntInf Object, it represents the time when Acc was assigned.
Syntax
datValue = object.Actm
object.Actm = datValue
Return Value
Date
Related Objects
AccFail Object, AccLog Object, EmplSec Object, EvntInf Object
ActmFlag Property
See Field Flag Properties.
Syntax
lngValue = object.ActmFlag
object.ActmFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
AccFail Object, AccLog Object, EmplSec Object, EvntInf Object
Actv Property
This property returns or sets the Active status of a Gage. See GageInfActvConstants for supported Actv values.
Syntax
lngValue = object.Actv
object.Actv = lngValue
Return Value
Long
Related Objects
GageInf Object, GageLoc Object
ActvFlag Property
See Field Flag Properties.
Syntax
lngValue = object.ActvFlag
object.ActvFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
GageInf Object, GageLoc Object
Admn Property
This property returns or sets the Administrative level for a role.
Syntax
lngValue = object.Admn
object.Admn = lngValue
Return Value
Long
Related Objects
AdmnFlag Property
See Field Flag Properties.
Syntax
lngValue = object.AdmnFlag
object.AdmnFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Aflag Property
This property returns or sets the alarm flag for specification limits. This property determines which specification limit values will trigger alarm violations as subgroup test values are evaluated. See SpecLimUseConstants for more on specific bitwise values.
Syntax
lngValue = object.Aflag
object.Aflag = lngValue
Return Value
Long
Related Objects
AflagFlag Property
See Field Flag Properties.
Syntax
lngValue = object.AflagFlag
object.AflagFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Alpha Property
Syntax
dblValue = object.Alpha
object.Alpha = dblValue
Return Value
Double
Related Objects
LotAcReq Object, LotAcSum Object
AlphaFlag Property
Syntax
lngValue = object.AlphaFlag
object.AlphaFlag = lngValue
Return Value
SQLFlagConstants
Related Objects
LotAcReq Object, LotAcSum Object
Alr Property
This property returns or sets Alarm Rules. The bits in this bitwise property represent alarm definitions. The first bit (AlrRule.Alr And 1) represents the first Alarm Definition Rule (AlrDef.Rule = 0) record. (Note the first Alarm Definition Rule is 0.) The second bit (AlrRule.Alr And 2) represents the second Alarm Definition Rule (AlrDef.Rule = 1). The third bit (AlrRule.Alr And 4) represents the third Alarm Rule Definition (AlrDef.Rule = 2).
The following code example displays all Alarm Definitions in a Checkbox Style list box. As it evaluates Alr, it set the applicable check marks.
Private Sub GetRule()
Dim oAlrRule As New iiaDatabase6.AlrRule
'NOTIFICATION RULE RECORD ID
oAlrRule.Alrm = 1011963529
oAlrRule.AlrmFlag = WhereEqual
'QUERY FOR NOTIFICATION RULE RECORD
If oAlrRule.Find(moDatabase) Then
'SHOW ENABLED DEFINITIONS
ListDefinitions oAlrRule.Alr
End If
End Sub
Private Sub ListDefinitions(ByVal Alr As Long)
Dim oRuleDef As New iiaDatabase6.RuleDef
'GET ALL RULE DEFINITIONS
oRuleDef.Buffer = 1000
'ORDER THEM BY F_RULE
oRuleDef.RuleFlag = OrderByAscending
'QUERY THE DATABASE
If oRuleDef.Find(moDatabase) Then
'ENUMERATE THROUGH EACH DEFINITION
Do
'ADD DEFINITION TO THE LIST
List1.AddItem oRuleDef.Name
'IF THE RULE HAS THIS DEFINITION SET, SET THE CHECK BOX
List1.Selected(List1.NewIndex) = Alr And (2 ^ oRuleDef.Rule)
Loop While oRuleDef.NextRec
End If
End Sub
Results of code example
Syntax
lngValue = object.Alr
object.Alr = lngValue
Return Value
Long
Related Objects
AlrFlag Property
See Field Flag Properties.
Syntax
lngValue = object.AlrFlag
object.AlrFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Alrm Property
This property returns or sets an Alarm Rule record ID.
Syntax
lngValue = object.Alrm
object.Alrm = lngValue
Return Value
Long
Related Objects
AlrmFlag Property
See Field Flag Properties.
Syntax
lngValue = object.AlrmFlag
object.AlrmFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Apcd Property
Returns and sets the Access Log's Application Code. See ApplicationCodes for a list of supported property values.
Syntax
lngValue = object.Apcd
object.Apcd = lngValue
Return Value
Long
Related Objects
ApcdFlag Property
See Field Flag Properties.
Syntax
lngValue = object.ApcdFlag
object.ApcdFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Aql Property
Syntax
dblValue = object.Aql
object.Aql = dblValue
Return Value
Double
Related Objects
LotAcReq Object, LotAcSum Object
AqlFlag Property
Syntax
lngValue = object.AqlFlag
object.AqlFlag = lngValue
Return Value
SQLFlagConstants
Related Objects
LotAcReq Object, LotAcSum Object
Aqtm Property
This property returns or sets the time a gage was acquired.
Syntax
lngValue = object.Aqtm
object.Aqtm = lngValue
Return Value
Long (See Converting between Long and Date)
Related Objects
GageInf Object, GageLoc Object
AqtmFlag Property
See Field Flag Properties.
Syntax
lngValue = object.AqtmFlag
object.AqtmFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
GageInf Object, GageLoc Object
Area Property
This property returns or sets an Area record ID.
Syntax
lngValue = object.Area
object.Area = lngValue
Return Value
Long
Related Objects
AreaInf Object, GageLoc Object, GageMov Object, PrcsUnt Object
AreaFlag Property
See Field Flag Properties.
Syntax
lngValue = object.AreaFlag
object.AreaFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
AreaInf Object, GageLoc Object, GageMov Object, PrcsUnt Object
Av Property
This property returns or sets the Appraiser Variation of a Gage Study Summary.
Syntax
dblValue = object.Av
object.Av = dblValue
Return Value
Double
Related Objects
AvFlag Property
See Field Flag Properties.
Syntax
lngValue = object.AvFlag
object.AvFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Bar Property
This property returns or sets the barometric pressure of Gage Calibration Information record.
Syntax
dblValue = object.Bar
object.Bar = dblValue
Return Value
Double
Related Objects
BarFlag Property
See Field Flag Properties.
Syntax
lngValue = object.BarFlag
object.BarFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Beta Property
Syntax
dblValue = object.Beta
object.Beta = dblValue
Return Value
Double
Related Objects
LotAcReq Object, LotAcSum Object
BetaFlag Property
Syntax
lngValue = object.BetaFlag
object.BetaFlag = lngValue
Return Value
SQLFlagConstants
Related Objects
LotAcReq Object, LotAcSum Object
Buffer Property
This property returns or sets the maximum number of records that a Accessing Tables using Table Objects can buffer. The default value is 1. Both the Find and AddBuffer methods utilize this setting. To access the buffered information within a table object, use FirstRec Function, LastRec Function, NextRec Function, PrevRec Function and GotoRec Function.
Syntax
lngValue = object.Buffer
object.Buffer = lngValue
Return Value
Long
Related Objects
AccDat Object, AccFail Object, AccGrp Object, AccLink Object, AccLinkV Object, AccLog Object, AlrRule Object, AreaInf Object, CacDat Object, CacGrp Object, CalCmt Object, CalDat Object, CalInf Object, CoInf Object, CtrlLim Object, CtrlSgrp Object, DbInf Object, DefDat Object, DefGrp Object, DefOpp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, EmplInf Object, EmplPch Object, EmplSec Object, EmplXtr Object, EvntCmt Object, EvntInf Object, GageInf Object, GageLoc Object, GageMdl Object, GageMov Object, GageRef Object, GageTyp Object, GageRef Object, GrrCmt Object, GrrDat Object, GrrExt Object, GrrInf Object, GrrSum Object, JobDat Object, JobDsc Object, JobGrp Object, JobOpDsc Object, JobOpLot Object, JobOp Object, JobOpPrcs Object, JobSum Object, LngDat Object, LngTyp Object, LotAcReq Object, LotAcSum Object, LotSum Object, MeasTyp Object, NetInf Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PartSn Object, PartTest Object, PrcdDat Object, PrcdInf Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RequDat Object, RequInf Object, RfcCode Object, RfcInf Object, RuleDef Object, SecuInf Object, SecuXtr Object, SgrpCmt Object, SgrpDsc Object, SgrpExt Object, SgrpInf Object, SgrpLot Object, SgrpTst Object, ShftDat Object, ShftGrp Object, SiteInf Object, SpcMail Object, SpecLim Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object, WkstXtr Object
Cac Property
This property returns or sets the Corrective Action Code record ID.
Syntax
lngValue = object.Cac
object.Cac = lngValue
Return Value
Long
Related Objects
CacFlag Property
See Field Flag Properties.
Syntax
lngValue = object.CacFlag
object.CacFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Caem Property
This property returns or sets the Employee record ID associated with the Cac for the Process Event.
Syntax
lngValue = object.Caem
object.Caem = lngValue
Return Value
Long
Related Objects
CaemFlag Property
See Field Flag Properties.
Syntax
lngValue = object.CaemFlag
object.CaemFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Cagp Property
This property returns or sets the Corrective Action Code Group record ID.
Syntax
lngValue = object.Cagp
object.Cagp = lngValue
Return Value
Long
Related Objects
AccDat Object, CacDat Object, CacGrp Object
CagpFlag Property
See Field Flag Properties.
Syntax
lngValue = object.CagpFlag
object.CagpFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
AccDat Object, CacDat Object, CacGrp Object
Catm Property
This property returns or sets the Time the Cac was assigned to the Process Event.
Syntax
datValue = object.Catm
object.Catm = datValue
Return Value
Date
Related Objects
CatmFlag Property
See Field Flag Properties.
Syntax
lngValue = object.CatmFlag
object.CatmFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Ccpnt Property
This property returns or sets the time that the component lot was closed.
Syntax
lngValue = object.Ccpnt
object.Ccpnt = lngValue
Return Value
Long (See Converting between Long and Date)
Related Objects
CcpntFlag Property
See Field Flag Properties.
Syntax
lngValue = object.CcpntFlag
object.CcpntFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Chrt Property
This property returns or sets the chart type that the Alarm Rule applies to. See ControlChartTypes.
Syntax
lngValue = object.Chrt
object.Chrt = lngValue
Return Value
Long
Related Objects
ChrtFlag Property
See Field Flag Properties.
Syntax
lngValue = object.ChrtFlag
object.ChrtFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Chtm Property
This property returns or sets the time that an Employee's password requires changing.
Syntax
datValue = object.Chtm
object.Chtm = datValue
Return Value
Date
Related Objects
EmplPch Object, EmplSec Object
ChtmFlag Property
See Field Flag Properties.
Syntax
lngValue = object.ChtmFlag
object.ChtmFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
EmplPch Object, EmplSec Object
Clby Property
This property returns or sets the Employee record ID that calibrated the gage last.
Syntax
lngValue = object.Clby
object.Clby = lngValue
Return Value
Long
Related Objects
GageInf Object, GageLoc Object
ClbyFlag Property
See Field Flag Properties.
Syntax
lngValue = object.ClbyFlag
object.ClbyFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
GageInf Object, GageLoc Object
Clid Property
This property returns or sets the Gage Calibration record ID.
Syntax
lngValue = object.Clid
object.Clid = lngValue
Return Value
Long
Related Objects
CalCmt Object, CalDat Object, CalInf Object
ClidFlag Property
See Field Flag Properties.
Syntax
lngValue = object.ClidFlag
object.ClidFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
CalCmt Object, CalDat Object, CalInf Object
Clno Property
This property returns or sets a sequential value for calibration data and calibration requirements.
Syntax
lngValue = object.Clno
object.Clno = lngValue
Return Value
Long
Related Objects
ClnoFlag Property
See Field Flag Properties.
Syntax
lngValue = object.ClnoFlag
object.ClnoFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Closed Property
Returns a time value indicating the date in which a Job-Operation or Lot was or will be closed.
Syntax
lngValue = object.Closed
object.Closed = lngValue
Return Value
Long (See Converting between Long and Date)
Related Objects
ClosedFlag Property
See Field Flag Properties.
Syntax
lngValue = object.ClosedFlag
object.ClosedFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Clot Property
This property returns or sets the Lot record ID that represents one of the components of a subgroup.
Syntax
lngValue = object.Clot
object.Clot = lngValue
Return Value
Long
Related Objects
ClotFlag Property
See Field Flag Properties.
Syntax
lngValue = object.ClotFlag
object.ClotFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Cltm Property
This property returns or sets a calibration time.
Syntax
lngValue = object.Cltm
object.Cltm = lngValue
Return Value
Long (See Converting between Long and Date)
Related Objects
CalInf Object, GageInf Object, GageLoc Object
CltmFlag Property
See Field Flag Properties.
Syntax
lngValue = object.CltmFlag
object.CltmFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
CalInf Object, GageInf Object, GageLoc Object
Cnt Property
This property returns or sets a count. Its use differs within each type of table.
- For JobSum and LotSum, it represents the number of subgroups used to process the other summary information within the record.
- For RuleDef, it represents the "out of" value. In the definition, 4 hits out of 5, for example, Cnt equals 5.
Syntax
lngValue = object.Cnt
object.Cnt = lngValue
Return Value
Long
Related Objects
JobSum Object, LotAcSum Object, LotSum Object, RuleDef Object
CntFlag Property
See Field Flag Properties.
Syntax
lngValue = object.CntFlag
object.CntFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
JobSum Object, LotAcSum Object, LotSum Object, RuleDef Object
Co Property
This property returns or sets the Company record ID.
Syntax
lngValue = object.Co
object.Co = lngValue
Return Value
Long
Related Objects
CoInf Object, DivInf Object, GageLoc Object, GageMov Object
Code Property
For AccFail Object and EmplSec, this property returns or sets the User Name. This Code is the name (not password) typed during login.
For RuleDef, this property returns or sets the abbreviation for the rule. This Code is displayed in control chart alarm violation markers.
Syntax
strValue = object.Code
object.Code = strValue
Return Value
String
Related Objects
AccFail Object, EmplSec Object, RuleDef Object
CodeFlag Property
See Field Flag Properties.
Syntax
lngValue = object.CodeFlag
object.CodeFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
AccFail Object, EmplSec Object, RuleDef Object
CoFlag Property
See Field Flag Properties.
Syntax
lngValue = object.CoFlag
object.CoFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
CoInf Object, DivInf Object, GageLoc Object, GageMov Object
Cost Property
This property returns or sets the cost for a gage or model of gage.
Syntax
dblValue = object.Cost
object.Cost = dblValue
Return Value
Double
Related Objects
GageInf Object, GageLoc Object, GageMdl Object, PartLot Object
CostFlag Property
See Field Flag Properties.
Syntax
lngValue = object.CostFlag
object.CostFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
GageInf Object, GageLoc Object, GageMdl Object, PartLot Object
Count Property
This read-only property returns the number of records. See Counting Records for more on this subject.
Syntax
varValue = object.Count (DB)
Return Value
Variant
Arguments
Name | Data Type | Description |
---|---|---|
DB |
Database |
Reference to a connected database object. |
Related Objects
AccDat Object, AccFail Object, AccGrp Object, AccLink Object, AccLinkV Object, AccLog Object, AlrRule Object, AreaInf Object, CacDat Object, CacGrp Object, CalCmt Object, CalDat Object, CalInf Object, CoInf Object, CtrlLim Object, CtrlSgrp Object, DbInf Object, DefDat Object, DefGrp Object, DefOpp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, EmplInf Object, EmplPch Object, EmplSec Object, EmplXtr Object, EvntCmt Object, EvntInf Object, GageInf Object, GageLoc Object, GageMdl Object, GageMov Object, GageRef Object, GageTyp Object, GageRef Object, GrrCmt Object, GrrDat Object, GrrExt Object, GrrInf Object, GrrSum Object, JobDat Object, JobDsc Object, JobGrp Object, JobOp Object, JobOpDsc Object, JobOpLot Object, JobOpPrcs Object, JobSum Object, LngDat Object, LngTyp Object, LotAcReq Object, LotAcSum Object, LotSum Object, NetInf Object, MeasTyp Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PartSn Object, PartTest Object, PrcdDat Object, PrcdInf Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RequDat Object, RequInf Object, RfcCode Object, RfcInf Object, RuleDef Object, SecuInf Object, SecuXtr Object, SgrpCmt Object, SgrpDsc Object, SgrpExt Object, SgrpInf Object, SgrpLot Object, SgrpTst Object, ShftDat Object, ShftGrp Object, SiteInf Object, SpcMail Object, SpecLim Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object, WkstXtr Object
CountRec Property
This read-only property returns the number of records buffered within a table object. For example, if Find returns 25 items, this is the value the CountRec will return.
Syntax
varValue = object.CountRec
Return Value
Variant
Related Objects
AccDat Object, AccFail Object, AccGrp Object, AccLink Object, AccLinkV Object, AccLog Object, AlrRule Object, AreaInf Object, CacDat Object, CacGrp Object, CalCmt Object, CalDat Object, CalInf Object, CoInf Object, CtrlLim Object, CtrlSgrp Object, DbInf Object, DefDat Object, DefGrp Object, DefOpp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, EmplInf Object, EmplPch Object, EmplSec Object, EmplXtr Object, EvntCmt Object, EvntInf Object, GageInf Object, GageLoc Object, GageMdl Object, GageMov Object, GageRef Object, GageTyp Object, GageRef Object, GrrCmt Object, GrrDat Object, GrrExt Object, GrrInf Object, GrrSum Object, JobDat Object, JobDsc Object, JobGrp Object, JobOp Object, JobOpDsc Object, JobOpLot Object, JobOpPrcs Object, JobSum Object, LngDat Object, LngTyp Object, LotAcReq Object, LotAcSum Object, LotSum Object, NetInf Object, MeasTyp Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PartSn Object, PartTest Object, PrcdDat Object, PrcdInf Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RequDat Object, RequInf Object, RfcCode Object, RfcInf Object, RuleDef Object, SecuInf Object, SecuXtr Object, SgrpCmt Object, SgrpDsc Object, SgrpExt Object, SgrpInf Object, SgrpLot Object, SgrpTst Object, ShftDat Object, ShftGrp Object, SiteInf Object, SpcMail Object, SpecLim Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object, WkstXtr Object
Cp Property
This property returns or sets the Cp (a capability index).
Syntax
dblValue = object.Cp
object.Cp = dblValue
Return Value
Double
Related Objects
CpFlag Property
See Field Flag Properties.
Syntax
lngValue = object.CpFlag
object.CpFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Cpk Property
This property returns or sets the Cpk (a capability index).
Syntax
dblValue = object.Cpk
object.Cpk = dblValue
Return Value
Double
Related Objects
CpkFlag Property
See Field Flag Properties.
Syntax
lngValue = object.CpkFlag
object.CpkFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Cpu Property
This property returns or sets a computer name.
Syntax
strValue = object.Cpu
object.Cpu = strValue
Return Value
String
Related Objects
CpuFlag Property
See Field Flag Properties.
Syntax
lngValue = object.CpuFlag
object.CpuFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Crtm Property
This property returns or sets a Create Time. This property represents the time in which a record was initially written to the database.
When adding records to the database, Crtm is automatically specified. That is, the Add method ignores the specified value.
Syntax
datValue = object.Crtm
object.Crtm = datValue
Return Value
Date
Related Objects
AccDat Object, AccFail Object, AccGrp Object, AccLink Object, AccLinkV Object, AccLog Object, AlrRule Object, AreaInf Object, CacDat Object, CacGrp Object, CalInf Object, CoInf Object, CtrlLim Object, CtrlSgrp Object, DbInf Object, DefDat Object, DefGrp Object, DefOpp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, EmplInf Object, EmplPch Object, EmplSec Object, EmplXtr Object, EvntCmt Object, EvntInf Object, GageInf Object, GageLoc Object, GageMdl Object, GageMov Object, GageTyp Object, GrrExt Object, GrrInf Object, GrrSum Object, JobDat Object, JobDsc Object, JobGrp Object, JobOp Object, JobOpDsc Object, JobOpLot Object, JobOpPrcs Object, JobSum Object, LngDat Object, LngTyp Object, LotAcReq Object, LotAcSum Object, LotSum Object, NetInf Object, MeasTyp Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PartSn Object, PartTest Object, PrcdInf Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RequInf Object, RfcCode Object, RfcInf Object, RuleDef Object, SecuInf Object, SecuXtr Object, SgrpCmt Object, SgrpExt Object, SgrpInf Object, ShftDat Object, ShftGrp Object, SiteInf Object, SpcMail Object, SpecLim Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object, WkstXtr Object
CrtmFlag Property
See Field Flag Properties.
Syntax
lngValue = object.CrtmFlag
object.CrtmFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
AccDat Object, AccFail Object, AccGrp Object, AccLink Object, AccLinkV Object, AccLog Object, AlrRule Object, AreaInf Object, CacDat Object, CacGrp Object, CalInf Object, CoInf Object, CtrlLim Object, CtrlSgrp Object, DbInf Object, DefDat Object, DefGrp Object, DefOpp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, EmplInf Object, EmplPch Object, EmplSec Object, EmplXtr Object, EvntCmt Object, EvntInf Object, GageInf Object, GageLoc Object, GageMdl Object, GageMov Object, GageTyp Object, GrrExt Object, GrrInf Object, GrrSum Object, JobDat Object, JobDsc Object, JobGrp Object, JobOp Object, JobOpDsc Object, JobOpLot Object, JobOpPrcs Object, JobSum Object, LngDat Object, LngTyp Object, LotAcReq Object, LotAcSum Object, LotSum Object, NetInf Object, MeasTyp Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PartSn Object, PartTest Object, PrcdInf Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RequInf Object, RfcCode Object, RfcInf Object, RuleDef Object, SecuInf Object, SecuXtr Object, SgrpCmt Object, SgrpExt Object, SgrpInf Object, ShftDat Object, ShftGrp Object, SiteInf Object, SpcMail Object, SpecLim Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object, WkstXtr Object
Ctest Property
This property returns or sets the time when a Lot is or will be closed for testing. InfinityQS uses this setting to prevent a "closed for test" lot from being assigned to subgroups.
Syntax
lngValue = object.Ctest
object.Ctest = lngValue
Return Value
Long (See Converting between Long and Date)
Related Objects
CtestFlag Property
See Field Flag Properties.
Syntax
lngValue = object.CtestFlag
object.CtestFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Ctrl Property
This property returns or sets a Control Limit record ID.
Syntax
lngValue = object.Ctrl
object.Ctrl = lngValue
Return Value
Long
Related Objects
CtrlLim Object, CtrlSgrp Object
CtrlFlag Property
See Field Flag Properties.
Syntax
lngValue = object.CtrlFlag
object.CtrlFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
CtrlLim Object, CtrlSgrp Object
Cust Property
This property returns or sets an Employee record ID as the "customer" assigned to a gage.
Syntax
lngValue = object.Cust
object.Cust = lngValue
Return Value
Long
Related Objects
GageInf Object, GageLoc Object
CustFlag Property
See Field Flag Properties.
Syntax
lngValue = object.CustFlag
object.CustFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
GageInf Object, GageLoc Object
Cyca Property
This property returns or sets the maximum time (in seconds) that a gage can be active before calibration is required.
Syntax
lngValue = object.Cyca
object.Cyca = lngValue
Return Value
Long (See Converting between Long and Date)
Related Objects
GageInf Object, GageLoc Object, GageMdl Object
CycaFlag Property
See Field Flag Properties.
Syntax
lngValue = object.CycaFlag
object.CycaFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
GageInf Object, GageLoc Object, GageMdl Object
Cycx Property
This property returns or sets the maximum time (in seconds) before calibration is required.
Syntax
lngValue = object.Cycx
object.Cycx = lngValue
Return Value
Long (See Converting between Long and Date)
Related Objects
GageInf Object, GageLoc Object, GageMdl Object
CycxFlag Property
See Field Flag Properties.
Syntax
lngValue = object.CycxFlag
object.CycxFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
GageInf Object, GageLoc Object, GageMdl Object
DatabaseInformation Property
This property returns or sets a reference to a DatabaseInformation object.
Syntax
Set objValue = object.DatabaseInformation
Return Value
Related Objects
Def Property
This property returns or sets a Defect Code record ID.
Syntax
lngValue = object.Def
object.Def = lngValue
Return Value
Long
Related Objects
DefDat Object, SgrpExt Object, SgrpTst Object
DefFlag Property
See Field Flag Properties.
Syntax
lngValue = object.DefFlag
object.DefFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
DefDat Object, SgrpExt Object, SgrpTst Object
Dept Property
This property returns or sets a Department record ID.
Syntax
lngValue = object.Dept
object.Dept = lngValue
Return Value
Long
Related Objects
AreaInf Object, DeptInf Object, EmplInf Object, GageLoc Object, GageMov Object
DeptFlag Property
See Field Flag Properties.
Syntax
lngValue = object.DeptFlag
object.DeptFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
AreaInf Object, DeptInf Object, EmplInf Object, GageLoc Object, GageMov Object
Desc Property
This property returns or sets a Descriptor record ID.
Syntax
lngValue = object.Desc
object.Desc = lngValue
Return Value
Long
Related Objects
DescDat Object, JobDsc Object, JobOpDsc Object, SgrpDsc Object
DescFlag Property
See Field Flag Properties.
Syntax
lngValue = object.DescFlag
object.DescFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
DescDat Object, JobDsc Object, JobOpDsc Object, SgrpDsc Object
Description Property
Not supported.
Syntax
strValue = object.Description
Return Value
String
Related Objects
FieldDefinition Object, TableDefinition Object
Dfgp Property
This property returns or sets a Defect Group record ID.
Syntax
lngValue = object.Dfgp
object.Dfgp = lngValue
Return Value
Long
Related Objects
DefDat Object, DefGrp Object, TestDat Object
DfgpFlag Property
See Field Flag Properties.
Syntax
lngValue = object.DfgpFlag
object.DfgpFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
DefDat Object, DefGrp Object, TestDat Object
Dfop Property
This property returns or sets a Defect Opportunity record ID.
Syntax
lngValue = object.Dfop
object.Dfop = lngValue
Return Value
Long
Related Objects
DfopFlag Property
See Field Flag Properties.
Syntax
lngValue = object.DfopFlag
object.DfopFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Div Property
Syntax
lngValue = object.Div
object.Div = lngValue
Return Value
Long
Related Objects
DivInf Object, PartDat Object, SiteInf Object
DivFlag Property
Syntax
lngValue = object.DivFlag
object.DivFlag = lngValue
Return Value
SQLFlagConstants
Related Objects
DivInf Object, PartDat Object, SiteInf Object
Dsbl Property
This property returns or sets a disabled. The supported values are.
0 ? Enabled
1 ? Disabled
2 ? Deleted
Syntax
lngValue = object.Dsbl
object.Dsbl = lngValue
Return Value
Long
Related Objects
AccDat Object, AccFail Object, AccGrp Object, AccLink Object, AccLinkV Object, AccLog Object, AlrRule Object, AreaInf Object, CacDat Object, CacGrp Object, CalCmt Object, CalDat Object, CalInf Object, CoInf Object, CtrlLim Object, CtrlSgrp Object, DbInf Object, DefDat Object, DefGrp Object, DefOpp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, EmplInf Object, EmplPch Object, EmplSec Object, EmplXtr Object, EvntCmt Object, EvntInf Object, GageInf Object, GageLoc Object, GageMdl Object, GageMov Object, GageRef Object, GageTyp Object, GageRef Object, GrrCmt Object, GrrDat Object, GrrExt Object, GrrInf Object, GrrSum Object, JobDat Object, JobDsc Object, JobGrp Object, JobOp Object, JobOpDsc Object, JobOpLot Object, JobOpPrcs Object, JobSum Object, LngDat Object, LngTyp Object, LotAcReq Object, LotAcSum Object, LotSum Object, NetInf Object, MeasTyp Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PartSn Object, PartTest Object, PrcdDat Object, PrcdInf Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RequDat Object, RequInf Object, RfcCode Object, RfcInf Object, RuleDef Object, SecuInf Object, SecuXtr Object, SgrpCmt Object, SgrpDsc Object, SgrpExt Object, SgrpInf Object, SgrpLot Object, SgrpTst Object, ShftDat Object, ShftGrp Object, SiteInf Object, SpcMail Object, SpecLim Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object, WkstXtr Object
DsblFlag Property
See Field Flag Properties.
Syntax
lngValue = object.DsblFlag
object.DsblFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
AccDat Object, AccFail Object, AccGrp Object, AccLink Object, AccLinkV Object, AccLog Object, AlrRule Object, AreaInf Object, CacDat Object, CacGrp Object, CalCmt Object, CalDat Object, CalInf Object, CoInf Object, CtrlLim Object, CtrlSgrp Object, DbInf Object, DefDat Object, DefGrp Object, DefOpp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, EmplInf Object, EmplPch Object, EmplSec Object, EmplXtr Object, EvntCmt Object, EvntInf Object, GageInf Object, GageLoc Object, GageMdl Object, GageMov Object, GageRef Object, GageTyp Object, GageRef Object, GrrCmt Object, GrrDat Object, GrrExt Object, GrrInf Object, GrrSum Object, JobDat Object, JobDsc Object, JobGrp Object, JobOp Object, JobOpDsc Object, JobOpLot Object, JobOpPrcs Object, JobSum Object, LngDat Object, LngTyp Object, LotAcReq Object, LotAcSum Object, LotSum Object, NetInf Object, MeasTyp Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PartSn Object, PartTest Object, PrcdDat Object, PrcdInf Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RequDat Object, RequInf Object, RfcCode Object, RfcInf Object, RuleDef Object, SecuInf Object, SecuXtr Object, SgrpCmt Object, SgrpDsc Object, SgrpExt Object, SgrpInf Object, SgrpLot Object, SgrpTst Object, ShftDat Object, ShftGrp Object, SiteInf Object, SpcMail Object, SpecLim Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object, WkstXtr Object
Dsgp Property
This property returns or sets a Descriptor Group record ID.
Syntax
lngValue = object.Dsgp
object.Dsgp = lngValue
Return Value
Long
Related Objects
DescDat Object, DescGrp Object, SgrpDsc Object
DsgpFlag Property
See Field Flag Properties.
Syntax
lngValue = object.DsgpFlag
object.DsgpFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
DescDat Object, DescGrp Object, SgrpDsc Object
DSN Property
This property returns or sets the Data Source Name. If the Database object has not been authenticated, the DSN will display a blank string. If DSN is set while currently connected an error will be raised.
Syntax
object.DSN = strValue
strValue = object.DSN
Return Value
String
Related Objects
Database Object, DatabaseInformation Object
DSNDefinition Property
Not supported. Reserved for Internal Use.
Syntax
strValue = object.DSNDefinition
object.DSNDefinition = strValue
Return Value
String
Related Objects
Due Property
This property returns or sets the time when a gage is due back.
Syntax
lngValue = object.Due
object.Due = lngValue
Return Value
Long (See Converting between Long and Date)
Related Objects
GageLoc Object, GageMov Object
DueFlag Property
See Field Flag Properties.
Syntax
lngValue = object.DueFlag
object.DueFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
GageLoc Object, GageMov Object
Edtm Property
This property returns or sets the Edit Time. This property represents the time in which a record was last updated in the database.
When editing records, Edtm is automatically specified. That is, the Edit method ignores any specified value.
Syntax
datValue = object.Edtm
object.Edtm = datValue
Return Value
Date
Related Objects
AccDat Object, AccFail Object, AccGrp Object, AccLink Object, AccLinkV Object, AccLog Object, AlrRule Object, AreaInf Object, CacDat Object, CacGrp Object, CalCmt Object, CalDat Object, CalInf Object, CoInf Object, CtrlLim Object, CtrlSgrp Object, DbInf Object, DefDat Object, DefGrp Object, DefOpp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, EmplInf Object, EmplPch Object, EmplSec Object, EmplXtr Object, EvntCmt Object, EvntInf Object, GageInf Object, GageLoc Object, GageMdl Object, GageMov Object, GageRef Object, GageTyp Object, GageRef Object, GrrCmt Object, GrrDat Object, GrrExt Object, GrrInf Object, GrrSum Object, JobDat Object, JobDsc Object, JobGrp Object, JobOp Object, JobOpDsc Object, JobOpLot Object, JobOpPrcs Object, JobSum Object, LngDat Object, LngTyp Object, LotAcReq Object, LotAcSum Object, LotSum Object, NetInf Object, MeasTyp Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PartSn Object, PartTest Object, PrcdDat Object, PrcdInf Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RequDat Object, RequInf Object, RfcCode Object, RfcInf Object, RuleDef Object, SecuInf Object, SecuXtr Object, SgrpCmt Object, SgrpDsc Object, SgrpExt Object, SgrpInf Object, SgrpLot Object, SgrpTst Object, ShftDat Object, ShftGrp Object, SiteInf Object, SpcMail Object, SpecLim Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object, WkstXtr Object
EdtmFlag Property
See Field Flag Properties.
Syntax
lngValue = object.EdtmFlag
object.EdtmFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
AccDat Object, AccFail Object, AccGrp Object, AccLink Object, AccLinkV Object, AccLog Object, AlrRule Object, AreaInf Object, CacDat Object, CacGrp Object, CalCmt Object, CalDat Object, CalInf Object, CoInf Object, CtrlLim Object, CtrlSgrp Object, DbInf Object, DefDat Object, DefGrp Object, DefOpp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, EmplInf Object, EmplPch Object, EmplSec Object, EmplXtr Object, EvntCmt Object, EvntInf Object, GageInf Object, GageLoc Object, GageMdl Object, GageMov Object, GageRef Object, GageTyp Object, GageRef Object, GrrCmt Object, GrrDat Object, GrrExt Object, GrrInf Object, GrrSum Object, JobDat Object, JobDsc Object, JobGrp Object, JobOp Object, JobOpDsc Object, JobOpLot Object, JobOpPrcs Object, JobSum Object, LngDat Object, LngTyp Object, LotAcReq Object, LotAcSum Object, LotSum Object, NetInf Object, MeasTyp Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PartSn Object, PartTest Object, PrcdDat Object, PrcdInf Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RequDat Object, RequInf Object, RfcCode Object, RfcInf Object, RuleDef Object, SecuInf Object, SecuXtr Object, SgrpCmt Object, SgrpDsc Object, SgrpExt Object, SgrpInf Object, SgrpLot Object, SgrpTst Object, ShftDat Object, ShftGrp Object, SiteInf Object, SpcMail Object, SpecLim Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object, WkstXtr Object
Eflag Property
This property returns or sets the Enabled Flag for specification limits. This property determines which specification limit values can be used. See SpecLimUseConstants for more on specific bitwise values.
Syntax
lngValue = object.Eflag
object.Eflag = lngValue
Return Value
Long
Related Objects
JobSum Object, LotAcSum Object, LotSum Object, SpecLim Object
EflagFlag Property
See Field Flag Properties.
Syntax
lngValue = object.EflagFlag
object.EflagFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
JobSum Object, LotAcSum Object, LotAcSum Object, LotSum Object, SpecLim Object
Eftm Property
This property returns or sets the time that defines when control limit record becomes effective for use.
Syntax
datValue = object.Eftm
object.Eftm = datValue
Return Value
Date
Related Objects
CtrlLim Object, LotAcReq Object
EftmFlag Property
See Field Flag Properties.
Syntax
lngValue = object.EftmFlag
object.EftmFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
CtrlLim Object, LotAcReq Object
Eltm Property
This property returns or sets the duration (number of seconds), it took to complete a gage calibration.
Syntax
lngValue = object.Eltm
object.Eltm = lngValue
Return Value
Long
Related Objects
EltmFlag Property
See Field Flag Properties.
Syntax
lngValue = object.EltmFlag
object.EltmFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Email Property
This property returns or sets an email address.
Syntax
strValue = object.Email
object.Email = strValue
Return Value
String
Related Objects
EmailFlag Property
See Field Flag Properties.
Syntax
lngValue = object.EmailFlag
object.EmailFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Empl Property (Name)
This property returns or sets an Employee name.
Syntax
strValue = object.Empl
object.Empl = strValue
Return Value
String
Related Objects
EvntCmt Object, SgrpCmt Object
Empl Property (ID)
This property returns or sets an Employee record ID.
Syntax
lngValue = object.Empl
object.Empl = lngValue
Return Value
Long
Related Objects
CalInf Object, EmplInf Object, EmplPch Object, EmplSec Object, EmplXtr Object, EvntInf Object, GageLoc Object, GageMov Object, PrcdInf Object, RequInf Object, SgrpExt Object, SgrpInf Object, SpcMail Object
EmplFlag Property
See Field Flag Properties.
Syntax
lngValue = object.EmplFlag
object.EmplFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
CalInf Object, EmplInf Object, EmplPch Object, EmplSec Object, EmplXtr Object, EvntCmt Object, EvntInf Object, GageLoc Object, GageMov Object, PrcdInf Object, RequInf Object, SgrpCmt Object, SgrpExt Object, SgrpInf Object, SpcMail Object
EmplInf Property
Returns a reference to an EmplInf object. See SPCMailRecipient Object for more about SPC Mail Recipients.
Syntax
Set objValue = object.EmplInf
Return Value
Related Objects
Epid Property
This property returns or sets an Employee name. This value is unique for every record in the Employee Information table. Unlike the Name property, Epid can be used to maintain a unique value, such as a Badge ID or Employee number. Typically, when an Employee Name is added within InfinityQS, Epid will be assigned the same default value.
Syntax
strValue = object.Epid
object.Epid = strValue
Return Value
String
Related Objects
EpidFlag Property
See Field Flag Properties.
Syntax
lngValue = object.EpidFlag
object.EpidFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Ev Property
This property returns or sets the Equipment Variation from a Gage Study.
Syntax
dblValue = object.Ev
object.Ev = dblValue
Return Value
Double
Related Objects
Evct Property
Returns ore sets the Event Count for Job and Lot Summary records.
Syntax
lngValue = object.Evct
object.Evct = lngValue
Return Value
Long
Related Objects
EvctFlag Property
See Field Flag Properties.
Syntax
lngValue = object.EvctFlag
object.EvctFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
EvFlag Property
See Field Flag Properties.
Syntax
lngValue = object.EvFlag
object.EvFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Evnt Property
This property returns or sets a Process Event record ID.
Syntax
lngValue = object.Evnt
object.Evnt = lngValue
Return Value
Long
Related Objects
EvntCmt Object, EvntInf Object
EvntFlag Property
See Field Flag Properties.
Syntax
lngValue = object.EvntFlag
object.EvntFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
EvntCmt Object, EvntInf Object
Evtm Property
Syntax
datValue = object.Evtm
object.Evtm = datValue
Return Value
Date
Related Objects
EvtmFlag Property
See Field Flag Properties.
Syntax
lngValue = object.EvtmFlag
object.EvtmFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Fctr Property
This property returns or sets the Factor value.
Syntax
dblValue = object.Fctr
object.Fctr = dblValue
Return Value
Double
Related Objects
AccDat Object, AccGrp Object, AccLinkV Object, AreaInf Object, CacDat Object, CacGrp Object, CoInf Object, CtrlLim Object, DefDat Object, DefGrp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, EmplInf Object, GageTyp Object, GrrExt Object, GrrSum Object, JobDat Object, JobGrp Object, NetInf Object, MeasTyp Object, PartDat Object, PartGrp Object, PartLot Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RfcCode Object, ShftDat Object, ShftGrp Object, SiteInf Object, SpecLim Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object
FctrFlag Property
See Field Flag Properties.
Syntax
lngValue = object.FctrFlag
object.FctrFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
AccDat Object, AccGrp Object, AccLinkV Object, AreaInf Object, CacDat Object, CacGrp Object, CoInf Object, CtrlLim Object, DefDat Object, DefGrp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, EmplInf Object, GageTyp Object, GrrExt Object, GrrSum Object, JobDat Object, JobGrp Object, NetInf Object, MeasTyp Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RfcCode Object, ShftDat Object, ShftGrp Object, SiteInf Object, SpecLim Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object
FieldCount Property
Not Supported. Reserved for Internal Use.
Syntax
lngValue = object.FieldCount
Return Value
Long
Related Objects
FieldType Property
Not Supported. Reserved for Internal Use.
Syntax
lngValue = object.FieldType
Return Value
Related Objects
Finl Property
This property returns or sets the Final Value resulting after a slight adjustment to the Initial Value (Init) was made.
Syntax
dblValue = object.Finl
object.Finl = dblValue
Return Value
Double
Related Objects
FinlFlag Property
See Field Flag Properties.
Syntax
lngValue = object.FinlFlag
object.FinlFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
FirstTableIndex Property
Return an Index number representing the first table.
Syntax
lngValue = object.FirstTableIndex
Return Value
Long
Fit Property
Not Supported. Reserved for future enhancements.
Syntax
lngValue = object.Fit
object.Fit = lngValue
Return Value
Long
Related Objects
FitFlag Property
See Field Flag Properties.
Syntax
lngValue = object.FitFlag
object.FitFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Fixed Property
This property returns or sets a value indicating whether a particular model of gage include Fixed values or variable values.
A value of 0 refers to models of gages that include variable values such as calipers or micrometers.
A value of 1 refers to models of gages that include fixed values such as Gage Blocks and Pin Gages.
Syntax
lngValue = object.Fixed
object.Fixed = lngValue
Return Value
Long
Related Objects
FixedFlag Property
See Field Flag Properties.
Syntax
lngValue = object.FixedFlag
object.FixedFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Flag Property
This property returns or sets a numeric value that means something different depending on the table.
Within SgrpInf, Flag supports these values.
0 ? Subgroup is enabled.
1 ? Subgroup is disabled.
2 ? Subgroup is incomplete.
Within the other tables, Flag is reserved for future enhancements.
Syntax
lngValue = object.Flag
object.Flag = lngValue
Return Value
Long
Related Objects
AccFail Object, AccLink Object, EvntInf Object, GrrDat Object, PartSn Object, SgrpExt Object, SgrpInf Object, SgrpTst Object, SpcMail Object
FlagFlag Property
See Field Flag Properties.
Syntax
lngValue = object.FlagFlag
object.FlagFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
AccFail Object, AccLink Object, EvntInf Object, GrrDat Object, PartSn Object, SgrpExt Object, SgrpInf Object, SgrpTst Object, SpcMail Object
Fntm Property
This property returns or sets the time indicates when something was or will be finished or completed.
Syntax
datValue = object.Fntm
object.Fntm = datValue
Return Value
Date
Related Objects
CtrlLim Object, GrrExt Object, GrrInf Object, GrrSum Object, JobDat Object, JobSum Object, LotAcSum Object, LotSum Object, PartRev Object
FntmFlag Property
See Field Flag Properties.
Syntax
lngValue = object.FntmFlag
object.FntmFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
CtrlLim Object, GrrExt Object, GrrInf Object, GrrSum Object, JobDat Object, JobSum Object, LotAcSum Object, LotSum Object, PartRev Object
ForeignKey Property
Unsupported. Reserved for internal use.
Syntax
boolValue = object.ForeignKey
Return Value
Boolean
Related Objects
Gage Property
This property returns or sets a Gage record ID.
Syntax
lngValue = object.Gage
object.Gage = lngValue
Return Value
Long
Related Objects
CalDat Object, CalInf Object, GageInf Object, GageLoc Object, GageMov Object, GageRef Object, GrrExt Object, GrrSum Object, SgrpExt Object, SgrpTst Object
GageFlag Property
See Field Flag Properties.
Syntax
lngValue = object.GageFlag
object.GageFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
CalDat Object, CalInf Object, GageInf Object, GageLoc Object, GageMov Object, GageRef Object, GrrExt Object, GrrSum Object, SgrpExt Object, SgrpTst Object
Gid Property
This property returns or sets a gage Name or Identifier.
Syntax
strValue = object.Gid
object.Gid = strValue
Return Value
String
Related Objects
GageInf Object, GageLoc Object
GidFlag Property
See Field Flag Properties.
Syntax
lngValue = object.GidFlag
object.GidFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
GageInf Object, GageLoc Object
Gmdl Property
This property returns or sets a Gage Model record ID.
Syntax
lngValue = object.Gmdl
object.Gmdl = lngValue
Return Value
Long
Related Objects
GageInf Object, GageLoc Object, GageMdl Object, GageRef Object, GrrExt Object, GrrSum Object
GmdlFlag Property
See Field Flag Properties.
Syntax
lngValue = object.GmdlFlag
object.GmdlFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
GageInf Object, GageLoc Object, GageMdl Object, GageRef Object, GrrExt Object, GrrSum Object
Gmid Property
This property returns or sets the Gage Movement record ID.
Syntax
lngValue = object.Gmid
object.Gmid = lngValue
Return Value
Long
Related Objects
GmidFlag Property
See Field Flag Properties.
Syntax
lngValue = object.GmidFlag
object.GmidFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Grr Property
This property returns or sets the Repeatability and Reproducibility of a gage study.
Syntax
dblValue = object.Grr
object.Grr = dblValue
Return Value
Double
Related Objects
GrrFlag Property
See Field Flag Properties.
Syntax
lngValue = object.GrrFlag
object.GrrFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Grsn Property
This property returns or sets a Gage Reference Serial Number.
Syntax
strValue = object.Grsn
object.Grsn = strValue
Return Value
String
Related Objects
GrsnFlag Property
See Field Flag Properties.
Syntax
lngValue = object.GrsnFlag
object.GrsnFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Gsid Property
This property returns or sets a Gage Studies record ID.
Syntax
lngValue = object.Gsid
object.Gsid = lngValue
Return Value
Long
Related Objects
GrrCmt Object, GrrDat Object, GrrExt Object, GrrInf Object, GrrSum Object
GsidFlag Property
See Field Flag Properties.
Syntax
lngValue = object.GsidFlag
object.GsidFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
GrrCmt Object, GrrDat Object, GrrExt Object, GrrInf Object, GrrSum Object
Gsn Property
This property returns or sets a Gage Serial Number.
Syntax
strValue = object.Gsn
object.Gsn = strValue
Return Value
String
Related Objects
GageInf Object, GageLoc Object
GsnFlag Property
See Field Flag Properties.
Syntax
lngValue = object.GsnFlag
object.GsnFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
GageInf Object, GageLoc Object
GtsApp Property
This property returns or sets the security privileges for the Gage Tracking System. See SecurityPrivilegeTypes for information on the available bit-wise values.
Syntax
lngValue = object.GtsApp
object.GtsApp = lngValue
Return Value
Long
Related Objects
GtsAppFlag Property
See Field Flag Properties.
Syntax
lngValue = object.GtsAppFlag
object.GtsAppFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Gtyp Property
This property returns or sets the Gage Type record ID.
Syntax
lngValue = object.Gtyp
object.Gtyp = lngValue
Return Value
Long
Related Objects
GageInf Object, GageLoc Object, GageMdl Object, GageTyp Object, GrrExt Object, GrrSum Object, RequDat Object
GtypFlag Property
See Field Flag Properties.
Syntax
lngValue = object.GtypFlag
object.GtypFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
GageInf Object, GageLoc Object, GageMdl Object, GageTyp Object, GrrExt Object, GrrSum Object, RequDat Object
Hits Property
This property returns or sets the number of an Alarm Rule Definition. In a rule such as "4 out of 5...", "4" represents the Hits value. "5" represents the Cnt.
Syntax
lngValue = object.Hits
object.Hits = lngValue
Return Value
Long
Related Objects
HitsFlag Property
See Field Flag Properties.
Syntax
lngValue = object.HitsFlag
object.HitsFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Hmdy Property
This property returns or sets a Humidity value.
Syntax
dblValue = object.Hmdy
object.Hmdy = dblValue
Return Value
Double
Related Objects
HmdyFlag Property
See Field Flag Properties.
Syntax
lngValue = object.HmdyFlag
object.HmdyFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Hold Property
This property returns or sets a time when a job or lot will go on Hold.
Syntax
lngValue = object.Hold
object.Hold = lngValue
Return Value
Long (See Converting between Long and Date)
Related Objects
HoldFlag Property
See Field Flag Properties.
Syntax
lngValue = object.HoldFlag
object.HoldFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
hWnd Property
This property returns or sets a handle to an active window. Within table objects, setting this value is optional. In the event an error message does appear, this window will get focus after the message box is closed. If a handle is not specified, the operating system will determine which window gets focus and could generate unexpected results.
See If the above VBS successfully connects to a ProFicient Database a message box will display "IsConnected = True". Otherwise it will display "False". for more on suppressing error messages.
Syntax
lngValue = object.hWnd
object.hWnd = lngValue
Return Value
Long
Related Objects
AccDat Object, AccFail Object, AccGrp Object, AccLink Object, AccLinkV Object, AccLog Object, AlrRule Object, AreaInf Object, CacDat Object, CacGrp Object, CalCmt Object, CalDat Object, CalInf Object, CoInf Object, CtrlLim Object, CtrlSgrp Object, DbInf Object, DefDat Object, DefGrp Object, DefOpp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, EmplInf Object, EmplPch Object, EmplSec Object, EmplXtr Object, EvntCmt Object, EvntInf Object, GageInf Object, GageLoc Object, GageMdl Object, GageMov Object, GageRef Object, GageTyp Object, GageRef Object, GrrCmt Object, GrrDat Object, GrrExt Object, GrrInf Object, GrrSum Object, JobDat Object, JobDsc Object, JobGrp Object, JobOp Object, JobOpDsc Object, JobOpLot Object, JobOpPrcs Object, JobSum Object, LngDat Object, LngTyp Object, LotAcReq Object, LotAcSum Object, LotSum Object, NetInf Object, MeasTyp Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PartSn Object, PartTest Object, PrcdDat Object, PrcdInf Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RequDat Object, RequInf Object, RfcCode Object, RfcInf Object, RuleDef Object, SecuInf Object, SecuXtr Object, SgrpCmt Object, SgrpDsc Object, SgrpExt Object, SgrpInf Object, SgrpLot Object, SgrpTst Object, ShftDat Object, ShftGrp Object, SiteInf Object, SpcMail Object, SpecLim Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object, WkstXtr Object
hWndOwner Property
This property returns or sets the handle of a window. When Database object error messages appear, this handle will get focus once the error message is closed. If a handle is not specified, the operating system will determine which window gets focus and could generate unexpected results.
See If the above VBS successfully connects to a ProFicient Database a message box will display "IsConnected = True". Otherwise it will display "False". for more on suppressing error messages.
Syntax
lngValue = object.hWndOwner
object.hWndOwner = lngValue
Return Value
Long
Related Objects
Id Property
Syntax
lngValue = object.Id
object.Id = lngValue
Return Value
Long
Related Objects
IdFlag Property
Syntax
lngValue = object.IdFlag
object.IdFlag = lngValue
Return Value
SQLFlagConstants
Related Objects
Index Property
Syntax
lngValue = object.Index
object.Index = lngValue
Return Value
Long
Related Objects
IndexFlag Property
Syntax
lngValue = object.IndexFlag
object.IndexFlag = lngValue
Return Value
SQLFlagConstants
Related Objects
Init Property
This property returns or sets an initial calibration value. This value represents the measurement taken before adjustments were made. To review the final value, use the Finl property. (See Finl Property.)
Syntax
dblValue = object.Init
object.Init = dblValue
Return Value
Double
Related Objects
InitFlag Property
See Field Flag Properties.
Syntax
lngValue = object.InitFlag
object.InitFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
IsConnected Property
Returns a Boolean value. True indicates the Database object is currently connected to a database and ready for use.
Syntax
boolValue = object.IsConnected
Return Value
Boolean
Related Objects
IsTimeField Property
Unsupported. Reserved for internal use.
Syntax
boolValue = object.IsTimeField
Return Value
Boolean
Related Objects
Jbds Property
This property returns or sets a Job Descriptor record ID.
Syntax
lngValue = object.Jbds
object.Jbds = lngValue
Return Value
Long
Related Objects
JbdsFlag Property
See Field Flag Properties.
Syntax
lngValue = object.JbdsFlag
object.JbdsFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Jbgp Property
This property returns or sets a Job Group record ID.
Syntax
lngValue = object.Jbgp
object.Jbgp = lngValue
Return Value
Long
Related Objects
JbgpFlag Property
See Field Flag Properties.
Syntax
lngValue = object.JbgpFlag
object.JbgpFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Jbop Property
This property returns or sets a Job Operation record ID.
Syntax
lngValue = object.Jbop
object.Jbop = lngValue
Return Value
Long
Related Objects
JobOp Object, JobOpDsc Object, JobOpLot Object, JobOpPrcs Object
JbopFlag Property
See Field Flag Properties.
Syntax
lngValue = object.JbsmFlag
object.JbsmFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
JobOp Object, JobOpDsc Object, JobOpLot Object, JobOpPrcs Object
Jbsm Property
This property returns or sets a Job Summary record ID.
Syntax
lngValue = object.Jbsm
object.Jbsm = lngValue
Return Value
Long
Related Objects
JbsmFlag Property
See Field Flag Properties.
Syntax
lngValue = object.JbsmFlag
object.JbsmFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Job Property
This property returns or sets a Job record ID.
Syntax
lngValue = object.Job
object.Job = lngValue
Return Value
Long
Related Objects
JobDat Object, JobDsc Object, JobOp Object, JobSum Object, SgrpExt Object, SgrpInf Object, SpecLim Object
JobFlag Property
See Field Flag Properties.
Syntax
lngValue = object.JobFlag
object.JobFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
JobDat Object, JobDsc Object, JobOp Object, JobSum Object, SgrpExt Object, SgrpInf Object, SpecLim Object
Jods Property
Syntax
lngValue = object.Jods
object.Jods = lngValue
Return Value
Long
Related Objects
JodsFlag Property
Syntax
lngValue = object.JodsFlag
object.JodsFlag = lngValue
Return Value
SQLFlagConstants
Related Objects
Jolt Property
Syntax
lngValue = object.Jolt
object.Jolt = lngValue
Return Value
Long
Related Objects
JoltFlag Property
Syntax
lngValue = object.JoltFlag
object.JoltFlag = lngValue
Return Value
SQLFlagConstants
Related Objects
Jopr Property
Syntax
lngValue = object.Jopr
object.Jopr = lngValue
Return Value
Long
Related Objects
JoprFlag Property
Syntax
lngValue = object.JoprFlag
object.JoprFlag = lngValue
Return Value
SQLFlagConstants
Related Objects
Lab Property
This property returns or sets a Company record ID. This value indicates the company where a gage went to be calibrated.
Syntax
lngValue = object.Lab
object.Lab = lngValue
Return Value
Long
Related Objects
LabFlag Property
See Field Flag Properties.
Syntax
lngValue = object.LabFlag
object.LabFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Lasr Property
Syntax
lngValue = object.Lasr
object.Lasr = lngValue
Return Value
Long
Related Objects
LasrFlag Property
Syntax
lngValue = object.LasrFlag
object.LasrFlag = lngValue
Return Value
SQLFlagConstants
Related Objects
Lass Property
Syntax
lngValue = object.Lass
object.Lass = lngValue
Return Value
Long
Related Objects
LassFlag Property
Syntax
lngValue = object.LassFlag
object.LassFlag = lngValue
Return Value
SQLFlagConstants
Related Objects
LastTableIndex Property
Returns an index number representing the last table index.
Syntax
lngValue = object.LastTableIndex
Return Value
Long
Lds Property
This property returns or sets a Lower Data Selection limit. This property is reserved for future enhancement.
Syntax
dblValue = object.Lds
object.Lds = dblValue
Return Value
Double
Related Objects
LdsFlag Property
See Field Flag Properties.
Syntax
lngValue = object.LdsFlag
object.LdsFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Length Property
Unsupported. Reserved for internal use.
Syntax
strValue = object.Length
Return Value
String
Related Objects
Lgb Property
This property returns or sets the Lower Warning Limit (Guard Band Limit).
Syntax
dblValue = object.Lgb
object.Lgb = dblValue
Return Value
Double
Related Objects
LgbFlag Property
See Field Flag Properties.
Syntax
lngValue = object.LgbFlag
object.LgbFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Line Property
This property returns or sets a Line number. Line is used to sequentially group a series of related records together. It is a way of grouping paragraphs of content across multiple records.
Syntax
lngValue = object.Line
object.Line = lngValue
Return Value
Long
Related Objects
CalCmt Object, GrrCmt Object, LngDat Object, PrcdDat Object
LineFlag Property
See Field Flag Properties.
Syntax
lngValue = object.LineFlag
object.LineFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
CalCmt Object, GrrCmt Object, LngDat Object, PrcdDat Object
Link Property
This property returns or sets the Assignable Cause Code Linkage record ID.
Syntax
lngValue = object.Link
object.Link = lngValue
Return Value
Long
Related Objects
AccLink Object, AccLinkV Object
LinkFlag Property
See Field Flag Properties.
Syntax
lngValue = object.LinkFlag
object.LinkFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
AccLink Object, AccLinkV Object
Lng Property
This property returns or sets the Language Type record ID.
Syntax
lngValue = object.Lng
object.Lng = lngValue
Return Value
Long
Related Objects
LngFlag Property
See Field Flag Properties.
Syntax
lngValue = object.LngFlag
object.LngFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Locked Property
This property returns or sets a time indicating when a User Account was or will be locked. When locked, this account cannot log in.
Syntax
lngValue = object.Locked
object.Locked = lngValue
Return Value
Long (See Converting between Long and Date)
Related Objects
LockedFlag Property
See Field Flag Properties.
Syntax
lngValue = object.LockedFlag
object.LockedFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Lot Property
This property returns or sets the Lot record ID.
Syntax
lngValue = object.Lot
object.Lot = lngValue
Return Value
Long
Related Objects
JobOpLot Object, LotAcSum Object, LotSum Object, PartLot Object, SgrpExt Object, SgrpInf Object, SpecLim Object
LotFlag Property
See Field Flag Properties.
Syntax
lngValue = object.LotFlag
object.LotFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
JobOpLot Object, LotAcSum Object, LotSum Object, PartLot Object, SgrpExt Object, SgrpInf Object, SpecLim Object
Lrl Property
For Specification Limit, Job Summary and Lot Summary records, this property returns or sets the Lower Reasonable Limit value.
For Gage Model, it returns or sets the Lower Range Limit.
Syntax
dblValue = object.Lrl
object.Lrl = dblValue
Return Value
Double
Related Objects
GageMdl Object, JobSum Object, LotSum Object, SpecLim Object
LrlFlag Property
See Field Flag Properties.
Syntax
lngValue = object.LrlFlag
object.LrlFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
GageMdl Object, JobSum Object, LotSum Object, SpecLim Object
Lsg Property
This property returns or sets the Lower Subgroup Limit.
Syntax
dblValue = object.Lsg
object.Lsg = dblValue
Return Value
Double
Related Objects
LsgFlag Property
See Field Flag Properties.
Syntax
lngValue = object.LsgFlag
object.LsgFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Lsl Property
This property returns or sets the Lower Specification Limit.
Syntax
dblValue = object.Lsl
object.Lsl = dblValue
Return Value
Double
Related Objects
JobSum Object, LotAcSum Object, LotSum Object, SpecLim Object
LslFlag Property
See Field Flag Properties.
Syntax
lngValue = object.LslFlag
object.LslFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
JobSum Object, LotAcSum Object, LotSum Object, SpecLim Object
Ltpd Property
Syntax
dblValue = object.Ltpd
object.Ltpd = dblValue
Return Value
Double
Related Objects
LotAcReq Object, LotAcSum Object
LtpdFlag Property
Syntax
lngValue = object.LtpdFlag
object.LtpdFlag = lngValue
Return Value
SQLFlagConstants
Related Objects
LotAcReq Object, LotAcSum Object
Ltsm Property
This property returns or sets the Lot Summary record ID.
Syntax
lngValue = object.Ltsm
object.Ltsm = lngValue
Return Value
Long
Related Objects
LtsmFlag Property
See Field Flag Properties.
Syntax
lngValue = object.LtsmFlag
object.LtsmFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Lwp Property
This property returns or sets the Lower Within Piece limits.
Syntax
dblValue = object.Lwp
object.Lwp = dblValue
Return Value
Double
Related Objects
LwpFlag Property
See Field Flag Properties.
Syntax
lngValue = object.LwpFlag
object.LwpFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Mail Property
This property returns or sets the SPC Mail record ID.
Syntax
lngValue = object.Mail
object.Mail = lngValue
Return Value
Long
Related Objects
MailFlag Property
See Field Flag Properties.
Syntax
lngValue = object.MailFlag
object.MailFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Max Property
This property returns or sets the maximum piece value.
Syntax
dblValue = object.Max
object.Max = dblValue
Return Value
Double
Related Objects
JobSum Object, LotAcSum Object, LotSum Object
MaxFlag Property
See Field Flag Properties.
Syntax
lngValue = object.MaxFlag
object.MaxFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
JobSum Object, LotAcSum Object, LotSum Object
Mdl Property
This property returns or sets the gage model name.
Syntax
strValue = object.Mdl
object.Mdl = strValue
Return Value
String
Related Objects
MdlFlag Property
See Field Flag Properties.
Syntax
lngValue = object.MdlFlag
object.MdlFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Mean Property
This property returns or sets a mean value.
Syntax
dblValue = object.Mean
object.Mean = dblValue
Return Value
Double
Related Objects
CtrlLim Object, JobSum Object, LotAcSum Object, LotSum Object
MeanFlag Property
See Field Flag Properties.
Syntax
lngValue = object.MeanFlag
object.MeanFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
CtrlLim Object, JobSum Object, LotAcSum Object, LotSum Object
Mfgr Property
This property returns or sets a Company record ID. It represents the gage manufacturer.
Syntax
lngValue = object.Mfgr
object.Mfgr = lngValue
Return Value
Long
Related Objects
GageInf Object, GageLoc Object, GageMdl Object
MfgrFlag Property
See Field Flag Properties.
Syntax
lngValue = object.MfgrFlag
object.MfgrFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
GageInf Object, GageLoc Object, GageMdl Object
Min Property
This property returns or sets the Minimum value.
Syntax
dblValue = object.Min
object.Min = dblValue
Return Value
Double
Related Objects
JobSum Object, LotAcSum Object, LotSum Object
MinFlag Property
See Field Flag Properties.
Syntax
lngValue = object.MinFlag
object.MinFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
JobSum Object, LotAcSum Object, LotSum Object
MsaApp Property
This property returns or sets the security privileges for the Measurement Systems Analysis System. See SecurityPrivilegeTypes for information on the available bit-wise values.
Syntax
lngValue = object.MsaApp
object.MsaApp = lngValue
Return Value
Long
Related Objects
MsaAppFlag Property
See Field Flag Properties.
Syntax
lngValue = object.MsaAppFlag
object.MsaAppFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Mstr Property
This property returns or sets the master gage property. A value of 1 represents a "Master Gage".
Syntax
lngValue = object.Mstr
object.Mstr = lngValue
Return Value
Long
Related Objects
GageInf Object, GageLoc Object
MstrFlag Property
See Field Flag Properties.
Syntax
lngValue = object.MstrFlag
object.MstrFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
GageInf Object, GageLoc Object
Mtol Property
This property returns or sets the lower tolerance (-tol) of a gage calibration requirement.
Syntax
dblValue = object.Mtol
object.Mtol = dblValue
Return Value
Double
Related Objects
MtolFlag Property
See Field Flag Properties.
Syntax
lngValue = object.MtolFlag
object.MtolFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Mtyp Property
This property returns or sets the Measurement Type record ID.
Syntax
lngValue = object.Mtyp
object.Mtyp = lngValue
Return Value
Long
Related Objects
CalDat Object, GrrExt Object, GrrSum Object, MeasTyp Object, RequDat Object, TestDat Object
MtypFlag Property
See Field Flag Properties.
Syntax
lngValue = object.MtypFlag
object.MtypFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
CalDat Object, GrrExt Object, GrrSum Object, MeasTyp Object, RequDat Object, TestDat Object
Mvtm Property
This property returns or sets the time when a gage was moved.
Syntax
lngValue = object.Mvtm
object.Mvtm = lngValue
Return Value
Long (See Converting between Long and Date)
Related Objects
GageInf Object, GageLoc Object, GageMov Object
MvtmFlag Property
See Field Flag Properties.
Syntax
lngValue = object.MvtmFlag
object.MvtmFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
GageInf Object, GageLoc Object, GageMov Object
Name Property
This property returns or sets a name.
Syntax
strValue = object.Name
object.Name = strValue
Return Value
String
Related Objects
AccDat Object, AccGrp Object, AccLinkV Object, AreaInf Object, CacDat Object, CacGrp Object, CoInf Object, DefDat Object, DefGrp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, EmplInf Object, EvntInf Object, FieldDefinition Object, GageRef Object, GageTyp Object, GageRef Object, GrrExt Object, GrrInf Object, JobDat Object, JobGrp Object, JobOp Object, LngTyp Object, NetInf Object, MeasTyp Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PartSn Object, PrcdInf Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RequInf Object, RfcCode Object, RuleDef Object, SecuInf Object, ShftDat Object, ShftGrp Object, SiteInf Object, TableDefinition Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object
NameFlag Property
See Field Flag Properties.
Syntax
lngValue = object.NameFlag
object.NameFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
AccDat Object, AccGrp Object, AccLinkV Object, AreaInf Object, CacDat Object, CacGrp Object, CoInf Object, DefDat Object, DefGrp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, EmplInf Object, EvntInf Object, GageRef Object, GageTyp Object, GageRef Object, GrrExt Object, GrrInf Object, JobDat Object, JobGrp Object, JobOp Object, LngTyp Object, NetInf Object, MeasTyp Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PartSn Object, PrcdInf Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RequInf Object, RfcCode Object, RuleDef Object, SecuInf Object, ShftDat Object, ShftGrp Object, SiteInf Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object
Net Property
Syntax
lngValue = object.Net
object.Net = lngValue
Return Value
Long
Related Objects
NetFlag Property
Syntax
lngValue = object.NetFlag
object.NetFlag = lngValue
Return Value
SQLFlagConstants
Related Objects
Nom Property
This property returns or sets the Nominal value.
Syntax
dblValue = object.Nom
object.Nom = dblValue
Return Value
Double
Related Objects
NomFlag Property
See Field Flag Properties.
Syntax
lngValue = object.NomFlag
object.NomFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Note Property
This property returns or sets the Note.
Syntax
strValue = object.Note
object.Note = strValue
Return Value
String
Related Objects
EvntCmt Object, GageMov Object, PrcdInf Object, RequInf Object, RfcInf Object, SgrpCmt Object
NoteFlag Property
See Field Flag Properties.
Syntax
lngValue = object.NoteFlag
object.NoteFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
EvntCmt Object, GageMov Object, PrcdInf Object, RequInf Object, RfcInf Object, SgrpCmt Object
Oor Property
This property returns or sets the number of pieces outside the Reasonable Limits (LRL and URL).
Syntax
lngValue = object.Oor
object.Oor = lngValue
Return Value
Long
Related Objects
OorFlag Property
See Field Flag Properties.
Syntax
lngValue = object.OorFlag
object.OorFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Oos Property
This property returns or sets the number of pieces outside the Specification Limits (LSL and USL).
Syntax
lngValue = object.Oos
object.Oos = lngValue
Return Value
Long
Related Objects
OosFlag Property
See Field Flag Properties.
Syntax
lngValue = object.OosFlag
object.OosFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Opened Property
This property returns or sets the date/time when a Job-Operation is opened for testing.
Syntax
lngValue = object.Opened
object.Opened = lngValue
Return Value
Long (See Converting between Long and Date)
Related Objects
OpenedFlag Property
See Field Flag Properties.
Syntax
lngValue = object.OpenedFlag
object.OpenedFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Oper Property
This property returns or sets the number of operators required to complete the Gage Study.
Syntax
lngValue = object.Oper
object.Oper = lngValue
Return Value
Long
Related Objects
OperFlag Property
See Field Flag Properties.
Syntax
lngValue = object.OperFlag
object.OperFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Opno Property
This property returns or sets a numeric value and defines the sequence within a series of Job Operations for a specific Job.
Syntax
lngValue = object.Opno
object.Opno = lngValue
Return Value
Long
Related Objects
OpnoFlag Property
See Field Flag Properties.
Syntax
lngValue = object.OpnoFlag
object.OpnoFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Opps Property
This property returns or sets the Defect Opportunity record ID.
Syntax
lngValue = object.Opps
object.Opps = lngValue
Return Value
Long
Related Objects
OppsFlag Property
See Field Flag Properties.
Syntax
lngValue = object.OppsFlag
object.OppsFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Opt Property
Syntax
lngValue = object.Opt
object.Opt = lngValue
Return Value
Long
Related Objects
LotAcReq Object, LotAcSum Object
OptFlag Property
Syntax
lngValue = object.OptFlag
object.OptFlag = lngValue
Return Value
SQLFlagConstants
Related Objects
LotAcReq Object, LotAcSum Object
Part Property
This property returns or sets the Part record ID.
Syntax
lngValue = object.Part
object.Part = lngValue
Return Value
Long
Related Objects
AccLink Object, AccLinkV Object, CtrlLim Object, DefOpp Object, EvntInf Object, GrrExt Object, GrrSum Object, JobOp Object, JobSum Object, LotAcReq Object, LotAcSum Object, PartDat Object, PartLot Object, PartRev Object, PartSn Object, PartTest Object, SgrpExt Object, SgrpInf Object, SgrpLot Object, SpcMail Object, SpecLim Object
PartFlag Property
See Field Flag Properties.
Syntax
lngValue = object.PartFlag
object.PartFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
AccLink Object, AccLinkV Object, CtrlLim Object, DefOpp Object, EvntInf Object, GrrExt Object, GrrSum Object, JobOp Object, JobSum Object, LotAcReq Object, LotAcSum Object, PartDat Object, PartLot Object, PartRev Object, PartSn Object, PartTest Object, SgrpExt Object, SgrpInf Object, SgrpLot Object, SpcMail Object, SpecLim Object
PartID Property
This property returns or sets the Part record ID.
Syntax
object.PartID = lngValue
lngValue = object.PartID
Return Value
Long
Related Objects
Password Property
This property returns or sets the InfinityQS Password used.
Syntax
object.Password = strValue
Return Value
String
Related Objects
Database Object, DatabaseInformation Object
Pdef Property
Syntax
dblValue = object.Pdef
object.Pdef = dblValue
Return Value
Double
Related Objects
PdefFlag Property
Syntax
lngValue = object.PdefFlag
object.PdefFlag = lngValue
Return Value
SQLFlagConstants
Related Objects
Pp Property
This property returns or sets Pp (Process Performance Index)
Syntax
dblValue = object.Pp
object.Pp = dblValue
Return Value
Double
Related Objects
PpFlag Property
See Field Flag Properties.
Syntax
lngValue = object.PpFlag
object.PpFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Ppk Property
This property returns or sets Ppk (Process Performance Index)
Syntax
dblValue = object.Ppk
object.Ppk = dblValue
Return Value
Double
Related Objects
PpkFlag Property
See Field Flag Properties.
Syntax
lngValue = object.PpkFlag
object.PpkFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Prcd Property
This property returns or sets the Procedure Information record ID.
Syntax
lngValue = object.Prcd
object.Prcd = lngValue
Return Value
Long
Related Objects
GageMdl Object, PrcdDat Object, PrcdInf Object
PrcdFlag Property
See Field Flag Properties.
Syntax
lngValue = object.PrcdFlag
object.PrcdFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
GageMdl Object, PrcdDat Object, PrcdInf Object
Prcs Property
This property returns or sets the Process record ID.
Syntax
lngValue = object.Prcs
object.Prcs = lngValue
Return Value
Long
Related Objects
AccLink Object, AccLinkV Object, AlrRule Object, CtrlLim Object, EvntInf Object, GrrExt Object, GrrSum Object, JobOpPrcs Object, LotAcReq Object, LotAcSum Object, PartLot Object, PrcsDat Object, SgrpExt Object, SgrpInf Object, SpcMail Object, SpecLim Object
PrcsFlag Property
See Field Flag Properties.
Syntax
lngValue = object.PrcsFlag
object.PrcsFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
AccLink Object, AccLinkV Object, AlrRule Object, CtrlLim Object, EvntInf Object, GrrExt Object, GrrSum Object, JobOpPrcs Object, LotAcReq Object, LotAcSum Object, PartLot Object, PrcsDat Object, SgrpExt Object, SgrpInf Object, SpcMail Object, SpecLim Object
Prgp Property
This property returns or sets the Process Group record ID.
Syntax
lngValue = object.Prgp
object.Prgp = lngValue
Return Value
Long
Related Objects
AccLink Object, AccLinkV Object, PrcsDat Object, PrcsGrp Object, SpcMail Object
PrgpFlag Property
See Field Flag Properties.
Syntax
lngValue = object.PrgpFlag
object.PrgpFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
AccLink Object, AccLinkV Object, PrcsDat Object, PrcsGrp Object, SpcMail Object
PrimaryKey Property
Unsupported. Reserved for internal use.
Syntax
boolValue = object.PrimaryKey
Return Value
Boolean
Related Objects
ProcessID Property
This property returns or sets the Process record ID.
Syntax
object.ProcessID = lngValue
lngValue = object.ProcessID
Return Value
Long
Related Objects
Prty Property
Unsupported.
Syntax
lngValue = object.Prty
object.Prty = lngValue
Return Value
Long
Related Objects
PrtyFlag Property
See Field Flag Properties.
Syntax
lngValue = object.PrtyFlag
object.PrtyFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Prut Property
Syntax
lngValue = object.Prut
object.Prut = lngValue
Return Value
Long
Related Objects
GageInf Object, GageLoc Object, GageMov Object, PrcsDat Object, PrcsUnt Object
PrutFlag Property
Syntax
lngValue = object.PrutFlag
object.PrutFlag = lngValue
Return Value
SQLFlagConstants
Related Objects
GageInf Object, GageLoc Object, GageMov Object, PrcsDat Object, PrcsUnt Object
Ptgp Property
This property returns or sets the Part Group record ID.
Syntax
lngValue = object.Ptgp
object.Ptgp = lngValue
Return Value
Long
Related Objects
AccLink Object, AccLinkV Object, PartDat Object, PartGrp Object, SpcMail Object
PtgpFlag Property
See Field Flag Properties.
Syntax
lngValue = object.PtgpFlag
object.PtgpFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
AccLink Object, AccLinkV Object, PartDat Object, PartGrp Object, SpcMail Object
Ptol Property
This property returns or sets the lower tolerance (-tol) of a gage calibration requirement.
Syntax
dblValue = object.Ptol
object.Ptol = dblValue
Return Value
Double
Related Objects
PtolFlag Property
See Field Flag Properties.
Syntax
lngValue = object.PtolFlag
object.PtolFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Ptrv Property
Syntax
lngValue = object.Ptrv
object.Ptrv = lngValue
Return Value
Long
Related Objects
PartRev Object, SgrpInf Object
PtrvFlag Property
Syntax
lngValue = object.PtrvFlag
object.PtrvFlag = lngValue
Return Value
SQLFlagConstants
Related Objects
PartRev Object, SgrpInf Object
Pv Property
This property returns or sets Part Variation.
Syntax
dblValue = object.Pv
object.Pv = dblValue
Return Value
Double
Related Objects
PvFlag Property
See Field Flag Properties.
Syntax
lngValue = object.PvFlag
object.PvFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Pwd Property
This property returns or sets a Password hash value.
Syntax
object.Pwd = strValue
strValue = object.Pwd
Return Value
String
Related Objects
DatabaseInformation Object, EmplPch Object, EmplSec Object
PwdFlag Property
See Field Flag Properties.
Syntax
lngValue = object.PwdFlag
object.PwdFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
EmplPch Object, EmplSec Object
Rcpnt Property
This property returns or sets a time when a lot was or will be released for component use.
Syntax
lngValue = object.Rcpnt
object.Rcpnt = lngValue
Return Value
Long (See Converting between Long and Date)
Related Objects
RcpntFlag Property
See Field Flag Properties.
Syntax
lngValue = object.RcpntFlag
object.RcpntFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Reconnect Property
Returns True if the Database is already connected.
If not already connected, an attempt is made to reestablish the connection. If successful, True is returned. If there is a desire to run in a stateless environment, wrap Reconnect and Disconnect around database activity.
NOTE: Running in a stateless environment will impact performance.
Syntax
boolValue = object.Reconnect
Return Value
Boolean
Related Objects
ReferenceField Property
Unsupported
Syntax
lngValue = object.ReferenceField
Return Value
Long
Related Objects
ReferenceKey Property
Unsupported
Syntax
boolValue = object.ReferenceKey
Return Value
Boolean
Related Objects
ReferenceTable Property
Unsupported
Syntax
lngValue = object.ReferenceTable
Return Value
Long
Related Objects
Rej Property
Syntax
lngValue = object.Rej
object.Rej = lngValue
Return Value
Long
Related Objects
RejFlag Property
Syntax
lngValue = object.RejFlag
object.RejFlag = lngValue
Return Value
SQLFlagConstants
Related Objects
Requ Property
This property returns or sets the Requirement Information record ID.
Syntax
lngValue = object.Requ
object.Requ = lngValue
Return Value
Long
Related Objects
GageMdl Object, RequDat Object, RequInf Object
RequFlag Property
See Field Flag Properties.
Syntax
lngValue = object.RequFlag
object.RequFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
GageMdl Object, RequDat Object, RequInf Object
Res Property (Long)
This property returns or sets the Language Resource record ID.
Syntax
lngValue = object.Res
object.Res = lngValue
Return Value
Long
Related Objects
Res Property (Double)
This property returns or sets the Resolution for a gage model.
Syntax
dblValue = object.Res
object.Res = dblValue
Return Value
Double
Related Objects
ResFlag Property
See Field Flag Properties.
Syntax
lngValue = object.ResFlag
object.ResFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Rev Property
Syntax
lngValue = object.Rev
object.Rev = lngValue
Return Value
Long
Related Objects
RevFlag Property
Syntax
lngValue = object.RevFlag
object.RevFlag = lngValue
Return Value
SQLFlagConstants
Related Objects
RFCEnabled Property
Syntax
boolValue = object.RFCEnabled
Return Value
Boolean
Related Objects
Rfc Property
This property returns or sets the Reason for Change record ID.
Syntax
lngValue = object.Rfc
object.Rfc = lngValue
Return Value
Long
Related Objects
AccDat Object, AccGrp Object, AccLink Object, AccLinkV Object, AlrRule Object, AreaInf Object, CacDat Object, CacGrp Object, CalCmt Object, CalDat Object, CalInf Object, CoInf Object, CtrlLim Object, CtrlSgrp Object, DbInf Object, DefDat Object, DefGrp Object, DefOpp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, EmplInf Object, EmplSec Object, EmplXtr Object, EvntCmt Object, EvntInf Object, GageInf Object, GageLoc Object, GageMdl Object, GageMov Object, GageRef Object, GageTyp Object, GageRef Object, GrrCmt Object, GrrDat Object, GrrExt Object, GrrInf Object, GrrSum Object, JobDat Object, JobDsc Object, JobGrp Object, JobOp Object, JobOpDsc Object, JobOpLot Object, JobOpPrcs Object, JobSum Object, LngDat Object, LngTyp Object, LotAcReq Object, LotAcSum Object, LotSum Object, NetInf Object, MeasTyp Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PartSn Object, PartTest Object, PrcdDat Object, PrcdInf Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RequDat Object, RequInf Object, RfcCode Object, RfcInf Object, RuleDef Object, SecuInf Object, SecuXtr Object, SgrpCmt Object, SgrpDsc Object, SgrpExt Object, SgrpInf Object, SgrpLot Object, SgrpTst Object, ShftDat Object, ShftGrp Object, SiteInf Object, SpcMail Object, SpecLim Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object, WkstXtr Object
RfcFlag Property
See Field Flag Properties.
Syntax
lngValue = object.RfcFlag
object.RfcFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
AccDat Object, AccGrp Object, AccLink Object, AccLinkV Object, AlrRule Object, AreaInf Object, CacDat Object, CacGrp Object, CalCmt Object, CalDat Object, CalInf Object, CoInf Object, CtrlLim Object, CtrlSgrp Object, DbInf Object, DefDat Object, DefGrp Object, DefOpp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, EmplInf Object, EmplSec Object, EmplXtr Object, EvntCmt Object, EvntInf Object, GageInf Object, GageLoc Object, GageMdl Object, GageMov Object, GageRef Object, GageTyp Object, GageRef Object, GrrCmt Object, GrrDat Object, GrrExt Object, GrrInf Object, GrrSum Object, JobDat Object, JobDsc Object, JobGrp Object, JobOp Object, JobOpDsc Object, JobOpLot Object, JobOpPrcs Object, JobSum Object, LngDat Object, LngTyp Object, LotAcReq Object, LotAcSum Object, LotSum Object, NetInf Object, MeasTyp Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PartSn Object, PartTest Object, PrcdDat Object, PrcdInf Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RequDat Object, RequInf Object, RfcCode Object, RfcInf Object, RuleDef Object, SecuInf Object, SecuXtr Object, SgrpCmt Object, SgrpDsc Object, SgrpExt Object, SgrpInf Object, SgrpLot Object, SgrpTst Object, ShftDat Object, ShftGrp Object, SiteInf Object, SpcMail Object, SpecLim Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object, WkstXtr Object
Rfno Property
This property returns or sets the reference number for a gage reference.
Syntax
lngValue = object.Rfno
object.Rfno = lngValue
Return Value
Long
Related Objects
CalDat Object, GageRef Object, GageRef Object, LngDat Object
RfnoFlag Property
See Field Flag Properties.
Syntax
lngValue = object.RfnoFlag
object.RfnoFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
CalDat Object, GageRef Object, GageRef Object, LngDat Object
Rntm Property
This property returns or sets the total time (in seconds) that a gage has been active.
Syntax
lngValue = object.Rntm
object.Rntm = lngValue
Return Value
Long (See Converting between Long and Date)
Related Objects
GageInf Object, GageLoc Object
RntmFlag Property
See Field Flag Properties.
Syntax
lngValue = object.RntmFlag
object.RntmFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
GageInf Object, GageLoc Object
Rrmar Property
This property returns or sets the R&R marginal value.
Syntax
dblValue = object.Rrmar
object.Rrmar = dblValue
Return Value
Double
Related Objects
RrmarFlag Property
See Field Flag Properties.
Syntax
lngValue = object.RrmarFlag
object.RrmarFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Rrmax Property
This property returns or sets the R&R Maximum value.
Syntax
dblValue = object.Rrmax
object.Rrmax = dblValue
Return Value
Double
Related Objects
RrmaxFlag Property
See Field Flag Properties.
Syntax
lngValue = object.RrmaxFlag
object.RrmaxFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Rscd Property
This property returns or sets the Reason Code record ID.
Syntax
lngValue = object.Rscd
object.Rscd = lngValue
Return Value
Long
Related Objects
RscdFlag Property
See Field Flag Properties.
Syntax
lngValue = object.RscdFlag
object.RscdFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Rtest Property
This property returns or sets the time in which a Lot is or will be released for testing.
Syntax
lngValue = object.Rtest
object.Rtest = lngValue
Return Value
Long (See Converting between Long and Date)
Related Objects
LotAcSum Object, PartLot Object
RtestFlag Property
See Field Flag Properties.
Syntax
lngValue = object.RtestFlag
object.RtestFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
LotAcSum Object, PartLot Object
Rtry Property
This property returns or sets the number of times a user can attempt to sign in for the user's account is locked.
Syntax
lngValue = object.Rtry
object.Rtry = lngValue
Return Value
Long
Related Objects
RtryFlag Property
See Field Flag Properties.
Syntax
lngValue = object.RtryFlag
object.RtryFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Rttm Property
This property returns or sets the time of the last unsuccessful sign in attempt.
Syntax
datValue = object.Rttm
object.Rttm = datValue
Return Value
Date
Related Objects
EmplSec Object, GageInf Object, GageLoc Object
RttmFlag Property
See Field Flag Properties.
Syntax
lngValue = object.RttmFlag
object.RttmFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
EmplSec Object, GageInf Object, GageLoc Object
Rule Property
This property returns or sets the Alarm Definition record ID.
Syntax
lngValue = object.Rule
object.Rule = lngValue
Return Value
Long
Related Objects
RuleFlag Property
See Field Flag Properties.
Syntax
lngValue = object.RuleFlag
object.RuleFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Rval Property
This property returns or sets the gage reference value.
Syntax
dblValue = object.Rval
object.Rval = dblValue
Return Value
Double
Related Objects
CalDat Object, GageRef Object, GageRef Object, RequDat Object
RvalFlag Property
See Field Flag Properties.
Syntax
lngValue = object.RvalFlag
object.RvalFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
CalDat Object, GageRef Object, GageRef Object, RequDat Object
Sbno Property
This property returns or sets the sub-test sequence number.
Syntax
lngValue = object.Sbno
object.Sbno = lngValue
Return Value
Long
Related Objects
SgrpExt Object, SgrpTst Object
SbnoFlag Property
See Field Flag Properties.
Syntax
lngValue = object.SbnoFlag
object.SbnoFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
SgrpExt Object, SgrpTst Object
Scal Property
This property returns or sets the number of digits to the right of the decimal.
Syntax
lngValue = object.Scal
object.Scal = lngValue
Return Value
Long
Related Objects
ScalFlag Property
See Field Flag Properties.
Syntax
lngValue = object.ScalFlag
object.ScalFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Sd_Act Property
Syntax
dblValue = object.Sd_Act
object.Sd_Act = dblValue
Return Value
Double
Related Objects
Sd_ActFlag Property
Syntax
lngValue = object.Sd_ActFlag
object.Sd_ActFlag = lngValue
Return Value
SQLFlagConstants
Related Objects
Sd_Spec Property
Syntax
dblValue = object.Sd_Spec
object.Sd_Spec = dblValue
Return Value
Double
Related Objects
LotAcReq Object, LotAcSum Object
Sd_SpecFlag Property
Syntax
lngValue = object.Sd_SpecFlag
object.Sd_SpecFlag = lngValue
Return Value
SQLFlagConstants
Related Objects
LotAcReq Object, LotAcSum Object
Sect Property
Unsupported
Syntax
lngValue = object.Sect
object.Sect = lngValue
Return Value
Long
Related Objects
SectFlag Property
See Field Flag Properties.
Syntax
lngValue = object.SectFlag
object.SectFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Secu Property
This property returns or sets the Role record ID.
Syntax
lngValue = object.Secu
object.Secu = lngValue
Return Value
Long
Related Objects
EmplSec Object, SecuInf Object, SecuXtr Object
SecuFlag Property
See Field Flag Properties.
Syntax
lngValue = object.SecuFlag
object.SecuFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
EmplSec Object, SecuInf Object, SecuXtr Object
Sgrp Property
This property returns or sets the Subgroup Information record ID.
Syntax
lngValue = object.Sgrp
object.Sgrp = lngValue
Return Value
Long
Related Objects
CtrlSgrp Object, GrrDat Object, SgrpCmt Object, SgrpDsc Object, SgrpExt Object, SgrpInf Object, SgrpLot Object, SgrpTst Object
SgrpFlag Property
See Field Flag Properties.
Syntax
lngValue = object.SgrpFlag
object.SgrpFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
CtrlSgrp Object, GrrDat Object, SgrpCmt Object, SgrpDsc Object, SgrpExt Object, SgrpInf Object, SgrpLot Object, SgrpTst Object
Sgsz Property
This property returns or sets the Subgroup Size.
Syntax
lngValue = object.Sgsz
object.Sgsz = lngValue
Return Value
Long
Related Objects
SgrpExt Object, SgrpInf Object
SgszFlag Property
See Field Flag Properties.
Syntax
lngValue = object.SgszFlag
object.SgszFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
SgrpExt Object, SgrpInf Object
Sgtm Property
This property returns or sets the Subgroup Time.
Syntax
datValue = object.Sgtm
object.Sgtm = datValue
Return Value
Date
Related Objects
EvntInf Object, SgrpExt Object, SgrpInf Object
SgtmFlag Property
See Field Flag Properties.
Syntax
lngValue = object.SgtmFlag
object.SgtmFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
EvntInf Object, SgrpExt Object, SgrpInf Object
Shft Property
This property returns or sets the Shift record ID. Within InfinityQS Shft replaced Split. However, for backward compatibility, the Splt property has been maintained. (See Splt Property.)
Syntax
lngValue = object.Shft
object.Shft = lngValue
Return Value
Long
Related Objects
ShftFlag Property
See Field Flag Properties.
Syntax
lngValue = object.ShftFlag
object.ShftFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Shgp Property
This property returns or sets the Shift Group record ID.
Syntax
lngValue = object.Shgp
object.Shgp = lngValue
Return Value
Long
Related Objects
ShftDat Object, ShftGrp Object
ShgpFlag Property
See Field Flag Properties.
Syntax
lngValue = object.ShgpFlag
object.ShgpFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
ShftDat Object, ShftGrp Object
Site Property
Syntax
lngValue = object.Site
object.Site = lngValue
Return Value
Long
Related Objects
DeptInf Object, JobDat Object, SiteInf Object
SiteFlag Property
Syntax
lngValue = object.SiteFlag
object.SiteFlag = lngValue
Return Value
SQLFlagConstants
Related Objects
DeptInf Object, JobDat Object, SiteInf Object
Size Property (Long)
This property returns or sets the number of subgroups within the Job Summary.
Syntax
lngValue = object.Size
object.Size = lngValue
Return Value
Long
Related Objects
JobSum Object, LotAcSum Object, PartLot Object
Size Property (Integer)
This property returns the maximum number of items that can be included within the Buffer Object object. The buffer object works in a circular fashion. That is, it maintains a pointer to the last element added and increments the pointer for each new item added. During an AddItem Statement call, if the incremented pointer exceeds Size, it resets back to the first element in the buffer, overwriting that item's value.
Syntax
intValue = object.Size
object.Size = intValue
Return Value
Integer
Related Objects
SizeFlag Property
See Field Flag Properties.
Syntax
lngValue = object.SizeFlag
object.SizeFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Sn Property
This property returns or sets the Serial Number record ID.
Syntax
lngValue = object.Sn
object.Sn = lngValue
Return Value
Long
Related Objects
PartSn Object, SgrpExt Object, SgrpTst Object
SnFlag Property
See Field Flag Properties.
Syntax
lngValue = object.SnFlag
object.SnFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
PartSn Object, SgrpExt Object, SgrpTst Object
Sp Property
This property returns or sets the piece-sigma.
Syntax
dblValue = object.Sp
object.Sp = dblValue
Return Value
Double
Related Objects
CtrlLim Object, JobSum Object, LotSum Object
SpcApp Property
This property returns or sets the security privileges for the SPC System. See SecurityPrivilegeTypes for information on the available bit-wise values.
Syntax
lngValue = object.SpcApp
object.SpcApp = lngValue
Return Value
Long
Related Objects
SpcAppFlag Property
See Field Flag Properties.
Syntax
lngValue = object.SpcAppFlag
object.SpcAppFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Spec Property
This property returns or sets the Specification Limits record ID.
Syntax
lngValue = object.Spec
object.Spec = lngValue
Return Value
Long
Related Objects
SpecFlag Property
See Field Flag Properties.
Syntax
lngValue = object.SpecFlag
object.SpecFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
SpFlag Property
See Field Flag Properties.
Syntax
lngValue = object.SpFlag
object.SpFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
CtrlLim Object, JobSum Object, LotSum Object
Spl Property
This property returns or sets the lower piece-sigma value.
Syntax
dblValue = object.Spl
object.Spl = dblValue
Return Value
Double
Related Objects
SplFlag Property
See Field Flag Properties.
Syntax
lngValue = object.SplFlag
object.SplFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Splt Property
This property returns or sets the Shift record ID. For backward compatibility, Splt was not renamed as Shft. (See Shft Property.)
Syntax
lngValue = object.Splt
object.Splt = lngValue
Return Value
Long
Related Objects
SgrpExt Object, SgrpInf Object
SpltFlag Property
See Field Flag Properties.
Syntax
lngValue = object.SpltFlag
object.SpltFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
SgrpExt Object, SgrpInf Object
Stat Property
Unsupported
Syntax
lngValue = object.Stat
object.Stat = lngValue
Return Value
Long
Related Objects
CalDat Object, CalInf Object, EmplInf Object, GageInf Object, GageMdl Object, GageMov Object, GrrExt Object, GrrInf Object, JobDat Object, LotAcSum Object
StatFlag Property
See Field Flag Properties.
Syntax
lngValue = object.StatFlag
object.StatFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
CalDat Object, CalInf Object, EmplInf Object, GageInf Object, GageMdl Object, GageMov Object, GrrExt Object, GrrInf Object, JobDat Object, LotAcSum Object
Stkr Property
This property returns or sets a gage calibration sticker (certificate) number.
Syntax
strValue = object.Stkr
object.Stkr = strValue
Return Value
String
Related Objects
StkrFlag Property
See Field Flag Properties.
Syntax
lngValue = object.StkrFlag
object.StkrFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Str1 Property
This property returns or sets a string value.
Syntax
strValue = object.Str1
object.Str1 = strValue
Return Value
String
Related Objects
DbInf Object, EmplXtr Object, PartTest Object, SecuXtr Object, WkstXtr Object
Str1Flag Property
See Field Flag Properties.
Syntax
lngValue = object.Str1Flag
object.Str1Flag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
DbInf Object, EmplXtr Object, PartTest Object, SecuXtr Object, WkstXtr Object
Str2 Property
This property returns or sets a string value.
Syntax
strValue = object.Str2
object.Str2 = strValue
Return Value
String
Related Objects
DbInf Object, EmplXtr Object, PartTest Object, SecuXtr Object, WkstXtr Object
Str2Flag Property
See Field Flag Properties.
Syntax
lngValue = object.Str2Flag
object.Str2Flag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
DbInf Object, EmplXtr Object, PartTest Object, SecuXtr Object, WkstXtr Object
Sttm Property
This property returns or sets a Start Time.
Syntax
datValue = object.Sttm
object.Sttm = datValue
Return Value
Date
Related Objects
CtrlLim Object, GrrExt Object, GrrInf Object, JobDat Object, JobSum Object, LotAcSum Object, LotSum Object, PartRev Object
SttmFlag Property
See Field Flag Properties.
Syntax
lngValue = object.SttmFlag
object.SttmFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
CtrlLim Object, GrrExt Object, GrrInf Object, JobDat Object, JobSum Object, LotAcSum Object, LotSum Object, PartRev Object
Sw Property
This property returns or sets a within-piece-sigma value.
Syntax
dblValue = object.Sw
object.Sw = dblValue
Return Value
Double
Related Objects
SwFlag Property
See Field Flag Properties.
Syntax
lngValue = object.SwFlag
object.SwFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Swl Property
This property returns or sets with lower within-piece-sigma value.
Syntax
dblValue = object.Swl
object.Swl = dblValue
Return Value
Double
Related Objects
SwlFlag Property
See Field Flag Properties.
Syntax
lngValue = object.SwlFlag
object.SwlFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Sys Property
This property returns or sets the system-level security privileges. See SecurityPrivilegeTypes for information on the available bit-wise values.
Syntax
lngValue = object.Sys
object.Sys = lngValue
Return Value
Long
Related Objects
SysFlag Property
See Field Flag Properties.
Syntax
lngValue = object.SysFlag
object.SysFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Tar Property
This property returns or sets the target value.
Syntax
dblValue = object.Tar
object.Tar = dblValue
Return Value
Double
Related Objects
JobSum Object, LotAcSum Object, LotSum Object, SpecLim Object
TarFlag Property
See Field Flag Properties.
Syntax
lngValue = object.TarFlag
object.TarFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
JobSum Object, LotAcSum Object, LotSum Object, SpecLim Object
Task Property
Returns a low-level database task handle. It is reserved for internal use.
Syntax
lngValue = object.Task
Return Value
Long
Related Objects
Temp Property
This property returns or sets a temperature value.
Syntax
dblValue = object.Temp
object.Temp = dblValue
Return Value
Double
Related Objects
TempFlag Property
See Field Flag Properties.
Syntax
lngValue = object.TempFlag
object.TempFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Test Property
This property returns or sets the Test record ID.
Syntax
lngValue = object.Test
object.Test = lngValue
Return Value
Long
Related Objects
AccLink Object, AccLinkV Object, AlrRule Object, CtrlLim Object, DefOpp Object, EvntInf Object, GrrExt Object, GrrSum Object, JobSum Object, LotAcReq Object, LotAcSum Object, LotSum Object, PartTest Object, SgrpCmt Object, SgrpExt Object, SgrpTst Object, SpcMail Object, SpecLim Object, TestDat Object
TestFlag Property
See Field Flag Properties.
Syntax
lngValue = object.TestFlag
object.TestFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
AccLink Object, AccLinkV Object, AlrRule Object, CtrlLim Object, DefOpp Object, EvntInf Object, GrrExt Object, GrrSum Object, JobSum Object, LotAcReq Object, LotAcSum Object, LotSum Object, PartTest Object, SgrpCmt Object, SgrpExt Object, SgrpTst Object, SpcMail Object, SpecLim Object, TestDat Object
TestID Property
This property returns or sets the Test record ID.
Syntax
object.TestID = lngValue
lngValue = object.TestID
Return Value
Long
Related Objects
Text Property
This property returns or sets a description. Typically, it is used as extended information about the Name.
Syntax
strValue = object.Text
object.Text = strValue
Return Value
String
Related Objects
AccDat Object, AccGrp Object, AccLinkV Object, AreaInf Object, CacDat Object, CacGrp Object, CalCmt Object, CoInf Object, DefDat Object, DefGrp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, GageTyp Object, GrrCmt Object, JobDat Object, JobGrp Object, JobOp Object, LngDat Object, LngTyp Object, NetInf Object, MeasTyp Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PrcdDat Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RfcCode Object, ShftDat Object, ShftGrp Object, SiteInf Object, SpecLim Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object
TextFlag Property
See Field Flag Properties.
Syntax
lngValue = object.TextFlag
object.TextFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
AccDat Object, AccGrp Object, AccLinkV Object, AreaInf Object, CacDat Object, CacGrp Object, CalCmt Object, CoInf Object, DefDat Object, DefGrp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, GageTyp Object, GrrCmt Object, JobDat Object, JobGrp Object, JobOp Object, LngDat Object, LngTyp Object, NetInf Object, MeasTyp Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PrcdDat Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RfcCode Object, ShftDat Object, ShftGrp Object, SiteInf Object, SpecLim Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object
Trial Property
This property returns or sets the number of trials to be conducted in a Gage Study.
Syntax
lngValue = object.Trial
object.Trial = lngValue
Return Value
Long
Related Objects
TrialFlag Property
See Field Flag Properties.
Syntax
lngValue = object.TrialFlag
object.TrialFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Tsgp Property
This property returns or sets the Test Group record ID.
Syntax
lngValue = object.Tsgp
object.Tsgp = lngValue
Return Value
Long
Related Objects
AccLink Object, AccLinkV Object, SpcMail Object, TestDat Object, TestGrp Object
TsgpFlag Property
See Field Flag Properties.
Syntax
lngValue = object.TsgpFlag
object.TsgpFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
AccLink Object, AccLinkV Object, SpcMail Object, TestDat Object, TestGrp Object
Tsno Property
This property returns or sets a subgroups test number. It can frequently refer to the piece or item number.
Syntax
lngValue = object.Tsno
object.Tsno = lngValue
Return Value
Long
Related Objects
GrrInf Object, SgrpCmt Object, SgrpDsc Object, SgrpExt Object, SgrpTst Object
TsnoFlag Property
See Field Flag Properties.
Syntax
lngValue = object.TsnoFlag
object.TsnoFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
GrrInf Object, SgrpCmt Object, SgrpDsc Object, SgrpExt Object, SgrpTst Object
Tv Property
This property returns or sets the Total Variation of Gage Study.
Syntax
dblValue = object.Tv
object.Tv = dblValue
Return Value
Double
Related Objects
Tval Property
Returns to sets the True Value of a gage calibration.
Syntax
dblValue = object.Tval
object.Tval = dblValue
Return Value
Double
Related Objects
TvalFlag Property
See Field Flag Properties.
Syntax
lngValue = object.TvalFlag
object.TvalFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
TvFlag Property
See Field Flag Properties.
Syntax
lngValue = object.TvFlag
object.TvFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Typ Property
This property returns or sets a generic table-specific value.
For Process Event (EvntInf), See EvntInfTypConstants.
Syntax
lngValue = object.Typ
object.Typ = lngValue
Return Value
Long
Related Objects
DbInf Object, EmplXtr Object, EvntInf Object, PartTest Object, RuleDef Object, SecuXtr Object, TestDat Object, WkstXtr Object
TypFlag Property
See Field Flag Properties.
Syntax
lngValue = object.TypFlag
object.TypFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
DbInf Object, EmplXtr Object, EvntInf Object, PartTest Object, RuleDef Object, SecuXtr Object, TestDat Object, WkstXtr Object
Uds Property
This property returns or sets the Upper Data Select limit.
Syntax
dblValue = object.Uds
object.Uds = dblValue
Return Value
Double
Related Objects
UdsFlag Property
See Field Flag Properties.
Syntax
lngValue = object.UdsFlag
object.UdsFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Ugb Property
This property returns or sets the Upper Warning Limit (Guard Band).
Syntax
dblValue = object.Ugb
object.Ugb = dblValue
Return Value
Double
Related Objects
UgbFlag Property
See Field Flag Properties.
Syntax
lngValue = object.UgbFlag
object.UgbFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
UID Property
Reserved for internal use
Syntax
object.UID = strValue
Return Value
String
Related Objects
Unique Property
Reserved for internal use
Syntax
boolValue = object.Unique
Return Value
Boolean
Related Objects
Url Property
This property returns or sets the Upper Reasonable Limit.
Syntax
dblValue = object.Url
object.Url = dblValue
Return Value
Double
Related Objects
GageMdl Object, JobSum Object, LotSum Object, SpecLim Object
UrlFlag Property
See Field Flag Properties.
Syntax
lngValue = object.UrlFlag
object.UrlFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
GageMdl Object, JobSum Object, LotSum Object, SpecLim Object
User Property (Long)
This property returns or sets the Employee record ID. With the Add method the specified value is ignored, and automatically set to the currently signed in user's Employee ID.
Syntax
lngValue = object.User
object.User = lngValue
Return Value
Long
Related Objects
AccDat Object, AccFail Object, AccGrp Object, AccLink Object, AccLinkV Object, AccLog Object, AlrRule Object, AreaInf Object, CacDat Object, CacGrp Object, CalCmt Object, CalDat Object, CalInf Object, CoInf Object, CtrlLim Object, CtrlSgrp Object, DbInf Object, DefDat Object, DefGrp Object, DefOpp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, EmplInf Object, EmplPch Object, EmplSec Object, EmplXtr Object, EvntCmt Object, EvntInf Object, GageInf Object, GageLoc Object, GageMdl Object, GageMov Object, GageRef Object, GageTyp Object, GageRef Object, GrrCmt Object, GrrDat Object, GrrExt Object, GrrInf Object, GrrSum Object, JobDat Object, JobDsc Object, JobGrp Object, JobOp Object, JobOpDsc Object, JobOpLot Object, JobOpPrcs Object, JobSum Object, LngDat Object, LngTyp Object, LotAcReq Object, LotAcSum Object, LotSum Object, NetInf Object, MeasTyp Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PartSn Object, PartTest Object, PrcdDat Object, PrcdInf Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RequDat Object, RequInf Object, RfcCode Object, RfcInf Object, RuleDef Object, SecuInf Object, SecuXtr Object, SgrpCmt Object, SgrpDsc Object, SgrpExt Object, SgrpInf Object, SgrpLot Object, SgrpTst Object, ShftDat Object, ShftGrp Object, SiteInf Object, SpcMail Object, SpecLim Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object, WkstXtr Object
User Property (String)
Syntax
object.User = strValue
Return Value
String
Related Objects
UserFlag Property
See Field Flag Properties.
Syntax
lngValue = object.UserFlag
object.UserFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
AccDat Object, AccFail Object, AccGrp Object, AccLink Object, AccLinkV Object, AccLog Object, AlrRule Object, AreaInf Object, CacDat Object, CacGrp Object, CalCmt Object, CalDat Object, CalInf Object, CoInf Object, CoInf Object, CtrlLim Object, CtrlSgrp Object, DbInf Object, DefDat Object, DefGrp Object, DefOpp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, EmplInf Object, EmplPch Object, EmplSec Object, EmplXtr Object, EvntCmt Object, EvntInf Object, GageInf Object, GageLoc Object, GageMdl Object, GageMov Object, GageRef Object, GageTyp Object, GageRef Object, GrrCmt Object, GrrDat Object, GrrExt Object, GrrInf Object, GrrSum Object, JobDat Object, JobDsc Object, JobGrp Object, JobOp Object, JobOpDsc Object, JobOpLot Object, JobOpPrcs Object, JobSum Object, LngDat Object, LngTyp Object, LotAcReq Object, LotAcSum Object, LotSum Object, NetInf Object, MeasTyp Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PartSn Object, PartTest Object, PrcdDat Object, PrcdInf Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RequDat Object, RequInf Object, RfcCode Object, RfcInf Object, RuleDef Object, SecuInf Object, SecuXtr Object, SgrpCmt Object, SgrpDsc Object, SgrpExt Object, SgrpInf Object, SgrpLot Object, SgrpTst Object, ShftDat Object, ShftGrp Object, SiteInf Object, SpcMail Object, SpecLim Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object, WkstXtr Object
UserName Property
This property returns or sets the InfinityQS User Name. See Automatically Signing In to a ProFicient Database for more on this subject.
Syntax
strValue = object.UserName
object.UserName = strValue
Return Value
String
Related Objects
Usg Property
This property returns or sets the Upper Subgroup limit.
Syntax
dblValue = object.Usg
object.Usg = dblValue
Return Value
Double
Related Objects
UsgFlag Property
See Field Flag Properties.
Syntax
lngValue = object.UsgFlag
object.UsgFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Usl Property
This property returns or sets the Upper Specification Limit
Syntax
dblValue = object.Usl
object.Usl = dblValue
Return Value
Double
Related Objects
JobSum Object, LotAcSum Object, LotSum Object, SpecLim Object
UslFlag Property
See Field Flag Properties.
Syntax
lngValue = object.UslFlag
object.UslFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
JobSum Object, LotAcSum Object, LotSum Object, SpecLim Object
Utyp Property
This property returns or sets the Unit Type record ID.
Syntax
lngValue = object.Utyp
object.Utyp = lngValue
Return Value
Long
Related Objects
CalDat Object, GageMdl Object, GrrExt Object, GrrSum Object, RequDat Object, TestDat Object, UnitTyp Object
UtypFlag Property
See Field Flag Properties.
Syntax
lngValue = object.UtypFlag
object.UtypFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
CalDat Object, GageMdl Object, GrrExt Object, GrrSum Object, RequDat Object, TestDat Object, UnitTyp Object
Uwp Property
This property returns or sets the Upper Within-In Piece specification limit.
Syntax
dblValue = object.Uwp
object.Uwp = dblValue
Return Value
Double
Related Objects
UwpFlag Property
See Field Flag Properties.
Syntax
lngValue = object.UwpFlag
object.UwpFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Val Property
For the SgrpTst object, this property returns or sets the subgroup test value.
For the DefDat object, this property returns or sets an increment value which is used by the SPC Data collection system.
Syntax
dblValue = object.Val
object.Val = dblValue
Return Value
Double
Related Objects
DefDat Object, SgrpExt Object, SgrpTst Object
ValFlag Property
See Field Flag Properties.
Syntax
lngValue = object.ValFlag
object.ValFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
DefDat Object, SgrpExt Object, SgrpTst Object
Var1 Property
This property returns or sets a numeric value. This property is typically used for system, role and user profile settings.
Syntax
lngValue = object.Var1
object.Var1 = lngValue
Return Value
Long
Related Objects
DbInf Object, EmplXtr Object, PartTest Object, SecuXtr Object, WkstXtr Object
Var1Flag Property
See Field Flag Properties.
Syntax
lngValue = object.Var1Flag
object.Var1Flag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
DbInf Object, EmplXtr Object, PartTest Object, SecuXtr Object, WkstXtr Object
Var2 Property
This property returns or sets a numeric value. This property is typically used for system, role and user profile settings.
Syntax
lngValue = object.Var2
object.Var2 = lngValue
Return Value
Long
Related Objects
DbInf Object, EmplXtr Object, PartTest Object, SecuXtr Object, WkstXtr Object
Var2Flag Property
See Field Flag Properties.
Syntax
lngValue = object.Var2Flag
object.Var2Flag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
DbInf Object, EmplXtr Object, PartTest Object, SecuXtr Object, WkstXtr Object
Var3 Property
This property returns or sets a numeric value. This property is typically used for system, role and user profile settings.
Syntax
lngValue = object.Var3
object.Var3 = lngValue
Return Value
Long
Related Objects
DbInf Object, EmplXtr Object, PartTest Object, SecuXtr Object, WkstXtr Object
Var3Flag Property
See Field Flag Properties.
Syntax
lngValue = object.Var3Flag
object.Var3Flag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
DbInf Object, EmplXtr Object, PartTest Object, SecuXtr Object, WkstXtr Object
Var4 Property
This property returns or sets a numeric value. This property is typically used for system, role and user profile settings.
Syntax
lngValue = object.Var4
object.Var4 = lngValue
Return Value
Long
Related Objects
DbInf Object, EmplXtr Object, PartTest Object, SecuXtr Object, WkstXtr Object
Var4Flag Property
See Field Flag Properties.
Syntax
lngValue = object.Var4Flag
object.Var4Flag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
DbInf Object, EmplXtr Object, PartTest Object, SecuXtr Object, WkstXtr Object
View Property
Reserved
Syntax
boolValue = object.View
Return Value
Boolean
Related Objects
Vndr Property
This property returns or sets a Company record ID which represents a Vendor.
Syntax
lngValue = object.Vndr
object.Vndr = lngValue
Return Value
Long
Related Objects
GageInf Object, GageLoc Object, GageMdl Object
VndrFlag Property
See Field Flag Properties.
Syntax
lngValue = object.VndrFlag
object.VndrFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
GageInf Object, GageLoc Object, GageMdl Object
Wiv Property
This property returns or sets a Within Variation value.
Syntax
dblValue = object.Wiv
object.Wiv = dblValue
Return Value
Double
Related Objects
WivFlag Property
See Field Flag Properties.
Syntax
lngValue = object.WivFlag
object.WivFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
Wkno Property
Reserved
Syntax
lngValue = object.Wkno
object.Wkno = lngValue
Return Value
Long
Related Objects
GageMov Object, SgrpExt Object, SgrpInf Object
WknoFlag Property
See Field Flag Properties.
Syntax
lngValue = object.WknoFlag
object.WknoFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
GageMov Object, SgrpExt Object, SgrpInf Object
Wkst Property
Syntax
lngValue = object.Wkst
object.Wkst = lngValue
Return Value
Long
Related Objects
WkstInf Object, WkstXtr Object
WkstFlag Property
Syntax
lngValue = object.WkstFlag
object.WkstFlag = lngValue
Return Value
SQLFlagConstants
Related Objects
WkstInf Object, WkstXtr Object
Xcal Property
This property returns or sets the time that the next gage calibration is required.
Syntax
lngValue = object.Xcal
object.Xcal = lngValue
Return Value
Long (See Converting between Long and Date)
Related Objects
GageInf Object, GageLoc Object
XcalFlag Property
See Field Flag Properties.
Syntax
lngValue = object.XcalFlag
object.XcalFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
GageInf Object, GageLoc Object
Xtra Property
This property returns or sets Role Extra or Employee Extra record ID.
Syntax
lngValue = object.Xtra
object.Xtra = lngValue
Return Value
Long
Related Objects
EmplXtr Object, SecuXtr Object, WkstXtr Object
XtraFlag Property
See Field Flag Properties.
Syntax
lngValue = object.XtraFlag
object.XtraFlag = lngValue
Return Value
See SQLFlagConstants.
Related Objects
EmplXtr Object, SecuXtr Object, WkstXtr Object
Methods
About Statement
If connected to a database, the Data Source Information dialog box is displayed.
Syntax
Call object.About
Related Objects
AccessCode Function
Reserved
Syntax
boolValue = object.AccessCode ([Code])
Return Value
Boolean
Arguments
Name |
Data Type |
Description |
---|---|---|
Code |
Long |
(Optional) |
Related Objects
Add Function
The function writes a record with used the specified table object properties. The following specified property values are ignored and set internally, however.
Crtm ? Create Time is specified by the Add method.
Edtm ? Edit Time is assigned the same value as Crtm.
User ? This property is assigned the Employee record ID for the currently signed in user.
Syntax
boolValue = object.Add (DB, [Options])
Return Value
Boolean
Arguments
Name |
Data Type |
Description |
---|---|---|
DB |
Database |
Reference to a connected Database object |
Options |
DatabaseAddConstants |
(Optional) Reserved. |
Related Objects
AccDat Object, AccFail Object, AccGrp Object, AccLink Object, AccLog Object, AlrRule Object, AreaInf Object, CacDat Object, CacGrp Object, CalCmt Object, CalDat Object, CalInf Object, CoInf Object, CtrlLim Object, CtrlSgrp Object, DbInf Object, DefDat Object, DefGrp Object, DefOpp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, EmplInf Object, EmplPch Object, EmplSec Object, EmplXtr Object, EvntCmt Object, EvntInf Object, GageInf Object, GageMdl Object, GageMov Object, GageRef Object, GageTyp Object, GageRef Object, GrrCmt Object, GrrDat Object, GrrInf Object, GrrSum Object, JobDat Object, JobDsc Object, JobGrp Object, JobOp Object, JobOpDsc Object, JobOpLot Object, JobOpPrcs Object, JobSum Object, LngDat Object, LngTyp Object, LotAcReq Object, LotAcSum Object, LotSum Object, NetInf Object, MeasTyp Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PartSn Object, PartTest Object, PrcdDat Object, PrcdInf Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RequDat Object, RequInf Object, RfcCode Object, RfcInf Object, RuleDef Object, SecuInf Object, SecuXtr Object, SgrpCmt Object, SgrpDsc Object, SgrpInf Object, SgrpLot Object, SgrpTst Object, ShftDat Object, ShftGrp Object, SiteInf Object, SpcMail Object, SpecLim Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object, WkstXtr Object
AddBuffer Function
Reserved
Syntax
boolValue = object.AddBuffer (DB, [Options])
Return Value
Boolean
Arguments
Name | Data Type | Description |
---|---|---|
DB |
Database |
|
Options |
DatabaseAddConstants |
(Optional) |
Related Objects
AccDat Object, AccFail Object, AccGrp Object, AccLink Object, AccLog Object, AlrRule Object, AreaInf Object, CacDat Object, CacGrp Object, CalCmt Object, CalDat Object, CalInf Object, CoInf Object, CtrlLim Object, CtrlSgrp Object, DbInf Object, DefDat Object, DefGrp Object, DefOpp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, EmplInf Object, EmplPch Object, EmplSec Object, EmplXtr Object, EvntCmt Object, EvntInf Object, GageInf Object, GageMdl Object, GageMov Object, GageRef Object, GageTyp Object, GageRef Object, GrrCmt Object, GrrDat Object, GrrInf Object, GrrSum Object, JobDat Object, JobDsc Object, JobGrp Object, JobOp Object, JobOpDsc Object, JobOpLot Object, JobOpPrcs Object, JobSum Object, LngDat Object, LngTyp Object, LotAcReq Object, LotAcSum Object, LotSum Object, NetInf Object, MeasTyp Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PartSn Object, PartTest Object, PrcdDat Object, PrcdInf Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RequDat Object, RequInf Object, RfcCode Object, RfcInf Object, RuleDef Object, SecuInf Object, SecuXtr Object, SgrpCmt Object, SgrpDsc Object, SgrpInf Object, SgrpLot Object, SgrpTst Object, ShftDat Object, ShftGrp Object, SiteInf Object, SpcMail Object, SpecLim Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object, WkstXtr Object
AddItem Statement
This method Saves an item to the Buffer object. See Buffer Object for more on this subject.
Syntax
Call object.AddItem (Name, ID, [ExtID])
Arguments
Name | Data Type | Description |
---|---|---|
Name |
String |
Name for the item. This will typically represent the record's Name. |
ID |
Long |
Numeric value associated with the Name. This will typically represent the record ID. |
ExtID |
Long |
(Optional) Secondary numeric value associates with the Name. This will typically maintain a related group ID. When buffering parts, for example, ExtID might represent the Part Group ID. |
Related Objects
AddRec Statement
Reserved
Syntax
Call object.AddRec (Value)
Arguments
Name | Data Type | Description |
---|---|---|
Value |
TableObject |
Pass a table object of the same type as this table object. |
Related Objects
AccDat Object, AccFail Object, AccGrp Object, AccLink Object, AccLinkV Object, AccLog Object, AlrRule Object, AreaInf Object, CacDat Object, CacGrp Object, CalCmt Object, CalDat Object, CalInf Object, CoInf Object, CtrlLim Object, CtrlSgrp Object, DbInf Object, DefDat Object, DefGrp Object, DefOpp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, EmplInf Object, EmplPch Object, EmplSec Object, EmplXtr Object, EvntCmt Object, EvntInf Object, GageInf Object, GageLoc Object, GageMdl Object, GageMov Object, GageRef Object, GageTyp Object, GageRef Object, GrrCmt Object, GrrDat Object, GrrExt Object, GrrInf Object, GrrSum Object, JobDat Object, JobDsc Object, JobGrp Object, JobOp Object, JobOpDsc Object, JobOpLot Object, JobOpPrcs Object, JobSum Object, LngDat Object, LngTyp Object, LotAcReq Object, LotAcSum Object, LotSum Object, NetInf Object, MeasTyp Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PartSn Object, PartTest Object, PrcdDat Object, PrcdInf Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RequDat Object, RequInf Object, RfcCode Object, RfcInf Object, RuleDef Object, SecuInf Object, SecuXtr Object, SgrpCmt Object, SgrpDsc Object, SgrpExt Object, SgrpInf Object, SgrpLot Object, SgrpTst Object, ShftDat Object, ShftGrp Object, SiteInf Object, SpcMail Object, SpecLim Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object, WkstXtr Object
Authenticate Function
Before a Database object can be used, it must be authenticated. Typically, Authenticate should be provided a handle to the active window. However, if there is no window, a value of 0 is acceptable.
When Authenticate is called, InfinityQS searches for a valid Custom Software License. At this time, the user may be notified that authenticate failed for any one of the following reasons.
- The database component has not been licensed. This is required by the Custom Software License (CSL).
- There are no available slots.
- The license information cannot be obtained for some reason.
Many coding examples are located under Using the Database Object.
Syntax
varValue = object.Authenticate (hWnd)
Return Value
Variant
Arguments
Name | Data Type | Description |
---|---|---|
hWnd |
Variant |
Handle to an active window. |
CSL Authentication Examples
When using a Custom Software License, the database object expects a long integer (int32). Typically this should be a handle to an active window. If a registration dialog is presented to complete the customer software license information this will be the window that gets focus when the dialog closes. If there is window handle, a long integer (int32) value of zero can be passed into Authenticate.
The following code snippet demonstrates CSL authentication using VBScript.
Dim oDatabase
Set oDatabase = CreateObject("iiaDatabase6.Database")
oDatabase.Authenticate 0 'PASS IN ZERO WHEN THERE IS NO WINDOW HANDLE
Dim boolAuthentic
boolAuthentic = oDatabase.IsAuthenticated
The following code snippet demonstrates CSL authentication using Visual Basic.
Dim oDatabase As iiaDatabase6.Database
Set oDatabase = New iiaDatabase6.Database
oDatabase.Authenticate Me.hWnd 'PASS IN A HANDLE TO THE WINDOW
Dim boolAuthentic As Boolean
boolAuthentic = oDatabase.IsAuthenticated
The following code snippet demonstrates CSL authentication using Visual C#. Because Authenticate expects a Variant and because Visual C# does not support the Variant data type, the parameter is passed in as an object of the type, long integer (int32).
iiaDatabase6.Database oDB = new iiaDatabase6.Database();
object oValue = new int();
oValue = Handle.ToInt32();
oDB.Authenticate(ref oValue);
bool boolAuthentic;
boolAuthentic = oDatabase.IsAuthenticated();
PSL Authentication Examples
When using a Partner Software License, Authenticate expects the registration code to be passed as a string. Contact your InfinityQS Account Manager to obtain authentic registration code.
The following code snippet demonstrates PSL authentication using VBScript.
Dim oDatabase
Set oDatabase = CreateObject("iiaDatabase6.Database")
oDatabase.Authenticate "ABCD1234ABCD1234ABCD123"
Dim boolAuthentic
boolAuthentic = oDatabase.IsAuthenticated
The following code snippet demonstrates PSL authentication using Visual Basic.
Dim oDatabase As iiaDatabase6.Database
Set oDatabase = New iiaDatabase6.Database
oDatabase.Authenticate "ABCD1234ABCD1234ABCD123"
Dim boolAuthentic As Boolean
boolAuthentic = oDatabase.IsAuthenticated
The following code snippen demonstrates PSL authentication using Visual C#.
iiaDatabase6.Database oDB = new iiaDatabase6.Database();
object oValue = new char();
oValue = "ABCD1234ABCD1234ABCD123";
oDB.Authenticate(ref oValue);
bool boolAuthentic;
boolAuthentic = oDatabase.IsAuthenticated();
Related Objects
BuildOrder Function
Reserved
Syntax
lngValue = object.BuildOrder (TableIndex)
Return Value
Long
Arguments
Name | Data Type | Description |
---|---|---|
TableIndex |
TableConstants |
Related Objects
CheckConnection Function
Syntax
boolValue = object.CheckConnection ([Reconnect])
Return Value
Boolean
Arguments
Name | Data Type | Description |
---|---|---|
Reconnect |
Boolean |
(Optional) |
Related Objects
Clear Statement
Clears the table object's internal buffer of records and clears all Field Flag Properties. Field Property values (e.g. Name, Text, Fctr) are not cleared, however.
Syntax
Call object.Clear
Related Objects
AccDat Object, AccFail Object, AccGrp Object, AccLink Object, AccLinkV Object, AccLog Object, AlrRule Object, AreaInf Object, Buffer Property, CacDat Object, CacGrp Object, CalCmt Object, CalDat Object, CalInf Object, CoInf Object, CtrlLim Object, CtrlSgrp Object, DbInf Object, DefDat Object, DefGrp Object, DefOpp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, EmplInf Object, EmplPch Object, EmplSec Object, EmplXtr Object, EvntCmt Object, EvntInf Object, GageInf Object, GageLoc Object, GageMdl Object, GageMov Object, GageRef Object, GageTyp Object, GageRef Object, GrrCmt Object, GrrDat Object, GrrExt Object, GrrInf Object, GrrSum Object, JobDat Object, JobDsc Object, JobGrp Object, JobOp Object, JobOpDsc Object, JobOpLot Object, JobOpPrcs Object, JobSum Object, LngDat Object, LngTyp Object, LotAcReq Object, LotAcSum Object, LotSum Object, NetInf Object, MeasTyp Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PartSn Object, PartTest Object, PrcdDat Object, PrcdInf Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RequDat Object, RequInf Object, RfcCode Object, RfcInf Object, RuleDef Object, SecuInf Object, SecuXtr Object, SgrpCmt Object, SgrpDsc Object, SgrpExt Object, SgrpInf Object, SgrpLot Object, SgrpTst Object, ShftDat Object, ShftGrp Object, SiteInf Object, SpcMail Object, SpecLim Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object, WkstXtr Object
ClearTables Function
Reserved
Syntax
boolValue = object.ClearTables ([hWnd])
Return Value
Boolean
Arguments
Name | Data Type | Description |
---|---|---|
hWnd |
Long |
(Optional) |
Related Objects
Connect Function
Use this method to sign in to the specified DSN.
See Using the Database Object for examples of getting connected.
Syntax
boolValue = object.Connect ([Options], [hWndOwner])
Return Value
Boolean
Arguments
Name | Data Type | Description |
---|---|---|
Options |
Long |
(Optional) See ConnectionTypes |
hWndOwner |
Long |
(Optional) Handle to active window |
Related Objects
ConnectedEmployee Function
Returns an EmplInf object that represents the currently signed in user. If not currently connected, or the database is not secured (does not require a username or password), ConnectEmployee returns Nothing.
Syntax
Set objValue = object.ConnectedEmployee
Return Value
Object ? The returned value will be of type, EmplInf Object
Related Objects
CreateDefaultAlarmRules Function
Reserved
Syntax
boolValue = object.CreateDefaultAlarmRules ([hWnd])
Return Value
Boolean
Arguments
Name | Data Type | Description |
---|---|---|
hWnd |
Long |
(Optional) Handle to active window |
Related Objects
CreateIndexes Function
Reserved
Syntax
boolValue = object.CreateIndexes ([hWnd])
Return Value
Boolean
Arguments
Name | Data Type | Description |
---|---|---|
hWnd |
Long |
(Optional) Handle to active window |
Related Objects
CreateTables Function
Reserved
Syntax
boolValue = object.CreateTables ([hWnd])
Return Value
Boolean
Arguments
Name | Data Type | Description |
---|---|---|
hWnd |
Long |
(Optional) Handle to active window |
Related Objects
Delete Function
This function deletes records from the table object's table. See Deleting Records for more on this subject.
Syntax
boolValue = object.Delete (DB)
Return Value
Boolean
Arguments
Name | Data Type | Description |
---|---|---|
DB |
Database |
Reference to a connected Database object. |
Related Objects
AccDat Object, AccFail Object, AccGrp Object, AccLink Object, AccLog Object, AlrRule Object, AreaInf Object, CacDat Object, CacGrp Object, CalCmt Object, CalDat Object, CalInf Object, CoInf Object, CtrlLim Object, CtrlSgrp Object, DbInf Object, DefDat Object, DefGrp Object, DefOpp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, EmplInf Object, EmplPch Object, EmplSec Object, EmplXtr Object, EvntCmt Object, EvntInf Object, GageInf Object, GageMdl Object, GageMov Object, GageRef Object, GageTyp Object, GageRef Object, GrrCmt Object, GrrDat Object, GrrInf Object, GrrSum Object, JobDat Object, JobDsc Object, JobGrp Object, JobOp Object, JobOpDsc Object, JobOpLot Object, JobOpPrcs Object, JobSum Object, LngDat Object, LngTyp Object, LotAcReq Object, LotAcSum Object, LotSum Object, NetInf Object, MeasTyp Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PartSn Object, PartTest Object, PrcdDat Object, PrcdInf Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RequDat Object, RequInf Object, RfcCode Object, RfcInf Object, RuleDef Object, SecuInf Object, SecuXtr Object, SgrpCmt Object, SgrpDsc Object, SgrpInf Object, SgrpLot Object, SgrpTst Object, ShftDat Object, ShftGrp Object, SiteInf Object, SpcMail Object, SpecLim Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object, WkstXtr Object
DeleteBuffer Function
Reserved.
Syntax
boolValue = object.DeleteBuffer (DB)
Return Value
Boolean
Arguments
Name | Data Type | Description |
---|---|---|
DB |
Database |
Related Objects
AccDat Object, AccFail Object, AccGrp Object, AccLink Object, AccLog Object, AlrRule Object, AreaInf Object, CacDat Object, CacGrp Object, CalCmt Object, CalDat Object, CalInf Object, CoInf Object, CtrlLim Object, CtrlSgrp Object, DbInf Object, DefDat Object, DefGrp Object, DefOpp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, EmplInf Object, EmplPch Object, EmplSec Object, EmplXtr Object, EvntCmt Object, EvntInf Object, GageInf Object, GageMdl Object, GageMov Object, GageRef Object, GageTyp Object, GageRef Object, GrrCmt Object, GrrDat Object, GrrInf Object, GrrSum Object, JobDat Object, JobDsc Object, JobGrp Object, JobOp Object, JobOpDsc Object, JobOpLot Object, JobOpPrcs Object, JobSum Object, LngDat Object, LngTyp Object, LotAcReq Object, LotAcSum Object, LotSum Object, NetInf Object, MeasTyp Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PartSn Object, PartTest Object, PrcdDat Object, PrcdInf Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RequDat Object, RequInf Object, RfcCode Object, RfcInf Object, RuleDef Object, SecuInf Object, SecuXtr Object, SgrpCmt Object, SgrpDsc Object, SgrpInf Object, SgrpLot Object, SgrpTst Object, ShftDat Object, ShftGrp Object, SiteInf Object, SpcMail Object, SpecLim Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object, WkstXtr Object
Disconnect Function
This function disconnects from the database. To reestablish a connection, See Connect Function or "Reconnect Property.
Syntax
boolValue = object.Disconnect
Return Value
Boolean
Related Objects
DropIndexes Function
Reserved
Syntax
boolValue = object.DropIndexes ([hWnd])
Return Value
Boolean
Arguments
Name | Data Type | Description |
---|---|---|
hWnd |
Long |
(Optional) Handle to active window |
Related Objects
DropTables Function
Reserved
Syntax
boolValue = object.DropTables ([hWnd])
Return Value
Boolean
Arguments
Name | Data Type | Description |
---|---|---|
hWnd |
Long |
(Optional) Handle to active window |
Related Objects
Edit Function
This function is used to update existing records. See Editing Records for more on this subject.
Syntax
boolValue = object.Edit (DB)
Return Value
Boolean
Arguments
Name | Data Type | Description |
---|---|---|
DB |
Database |
Reference to a connected Database object |
Related Objects
AccDat Object, AccFail Object, AccGrp Object, AccLink Object, AccLog Object, AlrRule Object, AreaInf Object, CacDat Object, CacGrp Object, CalCmt Object, CalDat Object, CalInf Object, CoInf Object, CtrlLim Object, CtrlSgrp Object, DbInf Object, DefDat Object, DefGrp Object, DefOpp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, EmplInf Object, EmplPch Object, EmplSec Object, EmplXtr Object, EvntCmt Object, EvntInf Object, GageInf Object, GageMdl Object, GageMov Object, GageRef Object, GageTyp Object, GageRef Object, GrrCmt Object, GrrDat Object, GrrInf Object, GrrSum Object, JobDat Object, JobDsc Object, JobGrp Object, JobOp Object, JobOpDsc Object, JobOpLot Object, JobOpPrcs Object, JobSum Object, LngDat Object, LngTyp Object, LotAcReq Object, LotAcSum Object, LotSum Object, NetInf Object, MeasTyp Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PartSn Object, PartTest Object, PrcdDat Object, PrcdInf Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RequDat Object, RequInf Object, RfcCode Object, RfcInf Object, RuleDef Object, SecuInf Object, SecuXtr Object, SgrpCmt Object, SgrpDsc Object, SgrpInf Object, SgrpLot Object, SgrpTst Object, ShftDat Object, ShftGrp Object, SiteInf Object, SpcMail Object, SpecLim Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object, WkstXtr Object
ExtID Function (Buffer Object)
Returns the extended ID assigned to an item within a Buffer object.
Syntax
lngValue = object.ExtID (ID)
Return Value
Long
Arguments
Name | Data Type | Description |
---|---|---|
ID |
Long |
A unique ID assigned to the item when it was initially added to the buffer |
Related Objects
FillList Function
Reserved
Syntax
boolValue = object.FillList (DB, ListToFill)
Return Value
Boolean
Arguments
Name | Data Type | Description |
---|---|---|
DB |
Database |
Reference to a connected Database object |
ListToFill |
Object |
Reference to a Listbox or Combobox. |
Related Objects
AccDat Object, AccFail Object, AccGrp Object, AccLink Object, AccLinkV Object, AccLog Object, AlrRule Object, AreaInf Object, CacDat Object, CacGrp Object, CalCmt Object, CalDat Object, CalInf Object, CoInf Object, CtrlLim Object, CtrlSgrp Object, DbInf Object, DefDat Object, DefGrp Object, DefOpp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, EmplInf Object, EmplPch Object, EmplSec Object, EmplXtr Object, EvntCmt Object, EvntInf Object, GageInf Object, GageLoc Object, GageMdl Object, GageMov Object, GageRef Object, GageTyp Object, GageRef Object, GrrCmt Object, GrrDat Object, GrrExt Object, GrrInf Object, GrrSum Object, JobDat Object, JobDsc Object, JobGrp Object, JobOp Object, JobOpDsc Object, JobOpLot Object, JobOpPrcs Object, JobSum Object, LngDat Object, LngTyp Object, LotAcReq Object, LotAcSum Object, LotSum Object, NetInf Object, MeasTyp Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PartSn Object, PartTest Object, PrcdDat Object, PrcdInf Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RequDat Object, RequInf Object, RfcCode Object, RfcInf Object, RuleDef Object, SecuInf Object, SecuXtr Object, SgrpCmt Object, SgrpDsc Object, SgrpExt Object, SgrpInf Object, SgrpLot Object, SgrpTst Object, ShftDat Object, ShftGrp Object, SiteInf Object, SpcMail Object, SpecLim Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object, WkstXtr Object
Find Function (Table Objects)
This function queries the database table for records meeting the specified criteria. See Finding Records for more on the subject.
Syntax
boolValue = object.Find (DB, [Options])
Return Value
Boolean
Arguments
Name | Data Type | Description |
---|---|---|
DB |
Database |
Reference to a connected Database object |
Options |
Long |
(Optional) Reserved |
Related Objects
AccDat Object, AccFail Object, AccGrp Object, AccLink Object, AccLinkV Object, AccLog Object, AlrRule Object, AreaInf Object, CacDat Object, CacGrp Object, CalCmt Object, CalDat Object, CalInf Object, CoInf Object, CtrlLim Object, CtrlSgrp Object, DbInf Object, DefDat Object, DefGrp Object, DefOpp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, EmplInf Object, EmplPch Object, EmplSec Object, EmplXtr Object, EvntCmt Object, EvntInf Object, GageInf Object, GageLoc Object, GageMdl Object, GageMov Object, GageRef Object, GageTyp Object, GageRef Object, GrrCmt Object, GrrDat Object, GrrExt Object, GrrInf Object, GrrSum Object, JobDat Object, JobDsc Object, JobGrp Object, JobOp Object, JobOpDsc Object, JobOpLot Object, JobOpPrcs Object, JobSum Object, LngDat Object, LngTyp Object, LotAcReq Object, LotAcSum Object, LotSum Object, NetInf Object, MeasTyp Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PartSn Object, PartTest Object, PrcdDat Object, PrcdInf Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RequDat Object, RequInf Object, RfcCode Object, RfcInf Object, RuleDef Object, SecuInf Object, SecuXtr Object, SgrpCmt Object, SgrpDsc Object, SgrpExt Object, SgrpInf Object, SgrpLot Object, SgrpTst Object, ShftDat Object, ShftGrp Object, SiteInf Object, SpcMail Object, SpecLim Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object, WkstXtr Object
Find Function (SPCMailRecipient)
This function queries the SPCMail table in search for employees that meet the specified Part, Process and Test criteria. Unlike SPCMail.Find, this function includes additional business logic within its search algorithms.
Syntax
boolValue = object.Find (Database)
Return Value
Boolean
Arguments
Name | Data Type | Description |
---|---|---|
Database |
Database |
Reference to a connected Database object |
Related Objects
FirstRec Function
This function updates the table object's field properties with the contents of the first buffered item (record).
The following code example points to the first item within a table object and then enumerates through all remaining items.
If oDefDat.FirstRec Then
Do
List1.AddItem oDefDat.Name & " (" & oDefDat.Fctr & ")"
Loop While oDefDat.NextRec
End If
Syntax
boolValue = object.FirstRec
Return Value
Boolean ? This function returns false if there are no buffered items.
Related Objects
AccDat Object, AccFail Object, AccGrp Object, AccLink Object, AccLinkV Object, AccLog Object, AlrRule Object, AreaInf Object, CacDat Object, CacGrp Object, CalCmt Object, CalDat Object, CalInf Object, CoInf Object, CtrlLim Object, CtrlSgrp Object, DbInf Object, DefDat Object, DefGrp Object, DefOpp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, EmplInf Object, EmplPch Object, EmplSec Object, EmplXtr Object, EvntCmt Object, EvntInf Object, GageInf Object, GageLoc Object, GageMdl Object, GageMov Object, GageRef Object, GageTyp Object, GageRef Object, GrrCmt Object, GrrDat Object, GrrExt Object, GrrInf Object, GrrSum Object, JobDat Object, JobDsc Object, JobGrp Object, JobOp Object, JobOpDsc Object, JobOpLot Object, JobOpPrcs Object, JobSum Object, LngDat Object, LngTyp Object, LotAcReq Object, LotAcSum Object, LotSum Object, NetInf Object, MeasTyp Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PartSn Object, PartTest Object, PrcdDat Object, PrcdInf Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RequDat Object, RequInf Object, RfcCode Object, RfcInf Object, RuleDef Object, SecuInf Object, SecuXtr Object, SgrpCmt Object, SgrpDsc Object, SgrpExt Object, SgrpInf Object, SgrpLot Object, SgrpTst Object, ShftDat Object, ShftGrp Object, SiteInf Object, SpcMail Object, SpecLim Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object, WkstXtr Object
GetData Function
Reserved
Syntax
strValue = object.GetData
Return Value
String
Related Objects
GetFieldDefinition Function
Reserved
Syntax
Set objValue = object.GetFieldDefinition (TableIndex, Field)
Return Value
Arguments
Name | Data Type | Description |
---|---|---|
TableIndex |
TableConstants |
|
Field |
Long |
Related Objects
GetTableDefinition Function
Reserved
Syntax
Set objValue = object.GetTableDefinition (TableIndex)
Return Value
Arguments
Name | Data Type | Description |
---|---|---|
TableIndex |
TableConstants |
See TableConstants. |
Related Objects
GotoRec Function
This function updates the table object's field properties with the contents of the buffered item (record) specified by Index.
The following code example walks through each record within a PartDat object and writes the part name to a list box.
Dim lngIndex As Long
Dim oPart As New iiaDatabase6.PartDat
oPart.Buffer = 1000
If oPart.Find(moDatabase) Then
For lngIndex = 1 To oPart.CountRec
oPart.GotoRec lngIndex
List1.AddItem oPart.Name
Next
End If
Syntax
boolValue = object.GotoRec (Index)
Return Value
Boolean ? This function returns false if unable to go to the specified index position.
Arguments
Name | Data Type | Description |
---|---|---|
Index |
Long |
Any numeric value between 1 and CountRec. |
Related Objects
AccDat Object, AccFail Object, AccGrp Object, AccLink Object, AccLinkV Object, AccLog Object, AlrRule Object, AreaInf Object, CacDat Object, CacGrp Object, CalCmt Object, CalDat Object, CalInf Object, CoInf Object, CtrlLim Object, CtrlSgrp Object, DbInf Object, DefDat Object, DefGrp Object, DefOpp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, EmplInf Object, EmplPch Object, EmplSec Object, EmplXtr Object, EvntCmt Object, EvntInf Object, GageInf Object, GageLoc Object, GageMdl Object, GageMov Object, GageRef Object, GageTyp Object, GageRef Object, GrrCmt Object, GrrDat Object, GrrExt Object, GrrInf Object, GrrSum Object, JobDat Object, JobDsc Object, JobGrp Object, JobOp Object, JobOpDsc Object, JobOpLot Object, JobOpPrcs Object, JobSum Object, LngDat Object, LngTyp Object, LotAcReq Object, LotAcSum Object, LotSum Object, NetInf Object, MeasTyp Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PartSn Object, PartTest Object, PrcdDat Object, PrcdInf Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RequDat Object, RequInf Object, RfcCode Object, RfcInf Object, RuleDef Object, SecuInf Object, SecuXtr Object, SgrpCmt Object, SgrpDsc Object, SgrpExt Object, SgrpInf Object, SgrpLot Object, SgrpTst Object, ShftDat Object, ShftGrp Object, SiteInf Object, SpcMail Object, SpecLim Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object, WkstXtr Object
HasPrivilege Function
Reserved
Syntax
boolValue = object.HasPrivilege (OwnerForm, Privilege, [Prompt])
Return Value
Boolean
Arguments
Name | Data Type | Description |
---|---|---|
OwnerForm |
Object |
Reference to Owner Form. |
Privilege |
SecurityPrivilegeTypes |
See SecurityPrivilegeTypes |
Prompt |
Boolean |
(Optional) Set to True to display an authorization dialog box. |
Related Objects
ID Function (Buffer Object)
This function returns an ID from a Buffer object based on the specified Name and optional ExtID. If the buffer includes unique names, ExtID is not required. However, in some situations, names may not be unique. For example, when buffering Descriptors, Name alone is not unique. For example, "Gold" might be part of the "Material" descriptor group and part of the "Color" descriptor group.
See Buffer Object for more information.
Syntax
lngValue = object.ID (Name, [ExtID])
Return Value
Long
Arguments
Name | Data Type | Description |
---|---|---|
Name |
String |
The name of an item within the Buffer object |
ExtID |
Long |
(Optional) Extended ID, such as a group ID. |
Related Objects
IDExists Function (Buffer Object)
This function evaluates a buffer object to determine whether or not the specified item exists.
Syntax
boolValue = object.IDExists (Name, [ExtID], [ID])
Return Value
Boolean
Arguments
Name | Data Type | Description |
---|---|---|
Name |
String |
Specifies the name of the item to search for. |
ExtID |
Long |
(Optional) If specified, the item must match both the Name and Extended ID. |
ID |
Long |
(Optional) If the ID is found, its value is returned through this argument. |
Related Objects
InitializeEventTables Function
Reserved
Syntax
boolValue = object.InitializeEventTables ([hWnd])
Return Value
Boolean
Arguments
Name | Data Type | Description |
---|---|---|
hWnd |
Long |
(Optional) |
Related Objects
InitializeFlags Statement
This procedure sets all field flags to the specified value. It is typically used to clear all flags, as the example below demonstrates.
oPartDat.InitializeFlags NoSQLFlags
Syntax
Call object.InitializeFlags (Value)
Arguments
Name | Data Type | Description |
---|---|---|
Value |
SQLFlagConstants |
See SQLFlagConstants |
Related Objects
AccDat Object, AccFail Object, AccGrp Object, AccLink Object, AccLinkV Object, AccLog Object, AlrRule Object, AreaInf Object, CacDat Object, CacGrp Object, CalCmt Object, CalDat Object, CalInf Object, CoInf Object, CtrlLim Object, CtrlSgrp Object, DbInf Object, DefDat Object, DefGrp Object, DefOpp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, EmplInf Object, EmplPch Object, EmplSec Object, EmplXtr Object, EvntCmt Object, EvntInf Object, GageInf Object, GageLoc Object, GageMdl Object, GageMov Object, GageRef Object, GageTyp Object, GageRef Object, GrrCmt Object, GrrDat Object, GrrExt Object, GrrInf Object, GrrSum Object, JobDat Object, JobDsc Object, JobGrp Object, JobOp Object, JobOpDsc Object, JobOpLot Object, JobOpPrcs Object, JobSum Object, LngDat Object, LngTyp Object, LotAcReq Object, LotAcSum Object, LotSum Object, NetInf Object, MeasTyp Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PartSn Object, PartTest Object, PrcdDat Object, PrcdInf Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RequDat Object, RequInf Object, RfcCode Object, RfcInf Object, RuleDef Object, SecuInf Object, SecuXtr Object, SgrpCmt Object, SgrpDsc Object, SgrpExt Object, SgrpInf Object, SgrpLot Object, SgrpTst Object, ShftDat Object, ShftGrp Object, SiteInf Object, SpcMail Object, SpecLim Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object, WkstXtr Object
InitializeSubgroupTables Function
Reserved
Syntax
boolValue = object.InitializeSubgroupTables ([hWnd])
Return Value
Boolean
Arguments
Name | Data Type | Description |
---|---|---|
hWnd |
Long |
(Optional) Handle to active window |
Related Objects
LastRec Function
This function updates the table object's field properties with the contents of the last buffered item.
Syntax
boolValue = object.LastRec
Return Value
Boolean ? This function returns false if there are no buffered items.
Related Objects
AccDat Object, AccFail Object, AccGrp Object, AccLink Object, AccLinkV Object, AccLog Object, AlrRule Object, AreaInf Object, CacDat Object, CacGrp Object, CalCmt Object, CalDat Object, CalInf Object, CoInf Object, CtrlLim Object, CtrlSgrp Object, DbInf Object, DefDat Object, DefGrp Object, DefOpp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, EmplInf Object, EmplPch Object, EmplSec Object, EmplXtr Object, EvntCmt Object, EvntInf Object, GageInf Object, GageLoc Object, GageMdl Object, GageMov Object, GageRef Object, GageTyp Object, GageRef Object, GrrCmt Object, GrrDat Object, GrrExt Object, GrrInf Object, GrrSum Object, JobDat Object, JobDsc Object, JobGrp Object, JobOp Object, JobOpDsc Object, JobOpLot Object, JobOpPrcs Object, JobSum Object, LngDat Object, LngTyp Object, LotAcReq Object, LotAcSum Object, LotSum Object, NetInf Object, MeasTyp Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PartSn Object, PartTest Object, PrcdDat Object, PrcdInf Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RequDat Object, RequInf Object, RfcCode Object, RfcInf Object, RuleDef Object, SecuInf Object, SecuXtr Object, SgrpCmt Object, SgrpDsc Object, SgrpExt Object, SgrpInf Object, SgrpLot Object, SgrpTst Object, ShftDat Object, ShftGrp Object, SiteInf Object, SpcMail Object, SpecLim Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object, WkstXtr Object
LoadTable Function
Reserved
Syntax
boolValue = object.LoadTable (TableIndex, Path, [hWnd])
Return Value
Boolean
Arguments
Name | Data Type | Description |
---|---|---|
TableIndex |
TableConstants |
|
Path |
String |
|
hWnd |
Long |
(Optional) Handle to active window |
Related Objects
Name Function (Buffer Object)
This function returns the Name within the Buffer object. See Buffer Object for more about the Buffer object.
Syntax
strValue = object.Name (ID)
Return Value
String
Arguments
Name | Data Type | Description |
---|---|---|
ID |
Long |
Unique value that typically represents a record ID |
Related Objects
NextRec Function
This function updates the table object's field properties with the contents of the next buffered item.
The following code example points to the first item within a table object and then enumerates through all remaining items using NextRec.
If oDefDat.FirstRec Then
Do
List1.AddItem oDefDat.Name & " (" & oDefDat.Fctr & ")"
Loop While oDefDat.NextRec
End If
Syntax
boolValue = object.NextRec
Return Value
Boolean ? This function returns false if there are no more buffered items.
Related Objects
AccDat Object, AccFail Object, AccGrp Object, AccLink Object, AccLinkV Object, AccLog Object, AlrRule Object, AreaInf Object, CacDat Object, CacGrp Object, CalCmt Object, CalDat Object, CalInf Object, CoInf Object, CtrlLim Object, CtrlSgrp Object, DbInf Object, DefDat Object, DefGrp Object, DefOpp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, EmplInf Object, EmplPch Object, EmplSec Object, EmplXtr Object, EvntCmt Object, EvntInf Object, GageInf Object, GageLoc Object, GageMdl Object, GageMov Object, GageRef Object, GageTyp Object, GageRef Object, GrrCmt Object, GrrDat Object, GrrExt Object, GrrInf Object, GrrSum Object, JobDat Object, JobDsc Object, JobGrp Object, JobOp Object, JobOpDsc Object, JobOpLot Object, JobOpPrcs Object, JobSum Object, LngDat Object, LngTyp Object, LotAcReq Object, LotAcSum Object, LotSum Object, NetInf Object, MeasTyp Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PartSn Object, PartTest Object, PrcdDat Object, PrcdInf Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RequDat Object, RequInf Object, RfcCode Object, RfcInf Object, RuleDef Object, SecuInf Object, SecuXtr Object, SgrpCmt Object, SgrpDsc Object, SgrpExt Object, SgrpInf Object, SgrpLot Object, SgrpTst Object, ShftDat Object, ShftGrp Object, SiteInf Object, SpcMail Object, SpecLim Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object, WkstXtr Object
PostErrors Function
This function defines how Database object errors shall be managed. See If the above VBS successfully connects to a ProFicient Database a message box will display "IsConnected = True". Otherwise it will display "False". for more on this function.
Syntax
lngValue = object.PostErrors (Value)
Return Value
Arguments
Name | Data Type | Description |
---|---|---|
Value |
DatabaseAccessErrorConstants |
See DatabaseAccessErrorConstants |
Related Objects
PrevRec Function
Syntax
boolValue = object.PrevRec
Return Value
Boolean ? This function returns false if there are no more buffered items.
Related Objects
AccDat Object, AccFail Object, AccGrp Object, AccLink Object, AccLinkV Object, AccLog Object, AlrRule Object, AreaInf Object, CacDat Object, CacGrp Object, CalCmt Object, CalDat Object, CalInf Object, CoInf Object, CtrlLim Object, CtrlSgrp Object, DbInf Object, DefDat Object, DefGrp Object, DefOpp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, EmplInf Object, EmplPch Object, EmplSec Object, EmplXtr Object, EvntCmt Object, EvntInf Object, GageInf Object, GageLoc Object, GageMdl Object, GageMov Object, GageRef Object, GageTyp Object, GageRef Object, GrrCmt Object, GrrDat Object, GrrExt Object, GrrInf Object, GrrSum Object, JobDat Object, JobDsc Object, JobGrp Object, JobOp Object, JobOpDsc Object, JobOpLot Object, JobOpPrcs Object, JobSum Object, LngDat Object, LngTyp Object, LotAcReq Object, LotAcSum Object, LotSum Object, NetInf Object, MeasTyp Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PartSn Object, PartTest Object, PrcdDat Object, PrcdInf Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RequDat Object, RequInf Object, RfcCode Object, RfcInf Object, RuleDef Object, SecuInf Object, SecuXtr Object, SgrpCmt Object, SgrpDsc Object, SgrpExt Object, SgrpInf Object, SgrpLot Object, SgrpTst Object, ShftDat Object, ShftGrp Object, SiteInf Object, SpcMail Object, SpecLim Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object, WkstXtr Object
RFCClear Statement
Syntax
Call object.RFCClear
Related Objects
RFCSet Function
Syntax
boolValue = object.RFCSet (RFCID, [hWnd])
Return Value
Boolean
Arguments
Name | Data Type | Description |
---|---|---|
RFCID |
Long |
|
hWnd |
Long |
(Optional) |
Related Objects
SetData Statement
Reserved
Syntax
Call object.SetData (Value)
Arguments
Name | Data Type | Description |
---|---|---|
Value |
String |
Related Objects
UpdateRec Statement
Reserved
Syntax
Call object.UpdateRec (Value)
Arguments
Name | Data Type | Description |
---|---|---|
Value |
Any Table Object |
Value must be of the same type of object as this table object |
Related Objects
AccDat Object, AccFail Object, AccGrp Object, AccLink Object, AccLinkV Object, AccLog Object, AlrRule Object, AreaInf Object, CacDat Object, CacGrp Object, CalCmt Object, CalDat Object, CalInf Object, CoInf Object, CtrlLim Object, CtrlSgrp Object, DbInf Object, DefDat Object, DefGrp Object, DefOpp Object, DeptInf Object, DescDat Object, DescGrp Object, DivInf Object, EmplInf Object, EmplPch Object, EmplSec Object, EmplXtr Object, EvntCmt Object, EvntInf Object, GageInf Object, GageLoc Object, GageMdl Object, GageMov Object, GageRef Object, GageTyp Object, GageRef Object, GrrCmt Object, GrrDat Object, GrrExt Object, GrrInf Object, GrrSum Object, JobDat Object, JobDsc Object, JobGrp Object, JobOp Object, JobOpDsc Object, JobOpLot Object, JobOpPrcs Object, JobSum Object, LngDat Object, LngTyp Object, LotAcReq Object, LotAcSum Object, LotSum Object, NetInf Object, MeasTyp Object, PartDat Object, PartGrp Object, PartLot Object, PartRev Object, PartSn Object, PartTest Object, PrcdDat Object, PrcdInf Object, PrcsDat Object, PrcsGrp Object, PrcsUnt Object, RequDat Object, RequInf Object, RfcCode Object, RfcInf Object, RuleDef Object, SecuInf Object, SecuXtr Object, SgrpCmt Object, SgrpDsc Object, SgrpExt Object, SgrpInf Object, SgrpLot Object, SgrpTst Object, ShftDat Object, ShftGrp Object, SiteInf Object, SpcMail Object, SpecLim Object, TestDat Object, TestGrp Object, UnitTyp Object, WkstInf Object, WkstXtr Object
Events
Connected Event
This event is fired anytime the Database object is connected to a database. To receive this event, a With Events reference to a Database object is required. The following example code displays a message box when the Connected event is fired.
Option Explicit
Private WithEvents moDatabase As iiaDatabase6.Database
Private Sub moDatabase_Connected()
MsgBox "Connected!"
End Sub
Syntax
Private Sub object_Connected
Related Objects
Disconnected Event
This event is fired anytime the Database object is disconnected. To receive this event, a With Events reference to a Database object is required. The following example code displays a message box when the Disconnected event is fired.
Option Explicit
Private WithEvents moDatabase As iiaDatabase6.Database
Private Sub moDatabase_Disconnected()
MsgBox "Disconnected!"
End Sub
Syntax
Private Sub object_Disconnected
Related Objects
Constants
ApplicationCodes
The following list represents all InfinityQS Application Codes. (See Apcd Property.)
Name | Value | Comments |
---|---|---|
ApcdSpcSe |
1000 |
InfinityQS SPC Standard Edition |
ApcdSpcXe |
1001 |
InfinityQS SPC Extended Edition |
ApcdSpcEe |
1002 |
InfinityQS SPC Enterprise Edition |
ApcdSpcFe |
1003 |
InfinityQS SPC FDA Edition |
ApcdGtsSe |
1004 |
InfinityQS Gage Tracking System |
ApcdMsaSe |
1005 |
InfinityQS Measurements Systems Analysis |
ApcdGageSvr |
1006 |
InfinityQS Gage Server |
ApcdDBM |
1007 |
InfinityQS Database Manager |
ApcdImp |
1008 |
InfinityQS Import Utility |
ApcdMerge |
1009 |
InfinityQS Merge Utility |
ApcdNpmSe |
1010 |
InfinityQS Network Process Monitor |
ApcdOpcdc |
1011 |
InfinityQS OPC Data Collector |
ApcdRTI |
1012 |
InfinityQS Real Time Import Utility |
ApcdSyncSe |
1013 |
InfinityQS Synchronization Utility |
ApcdLock |
1014 |
InfinityQS Account Lock Utility |
ApcdReset |
1015 |
InfinityQS Account Reset Utility |
ApcdSpcXfer |
1016 |
InfinityQS SPC Transfer Utility |
ApcdUndefined |
9999 |
Unsupported Application |
ControlChartTypes
The following list of values is used by the Chrt property. (See Chrt Property.) The values can be classified into 4 groups. And a single value from each group can be combined (ORed) to define the entire makeup of the control chart. The following example describes an XBar-Range Nominal control chart.
oAlrRule.Chrt = CCGraph1Xbar Or CCGraph2Range Or CCProcNominal
Graph 1 Chart Type
Name | Value | Comments |
---|---|---|
CCGraph1Mask |
3840 (&HF00) |
Masks out the bits used to define Graph 1 of the control chart |
CCGraph1Xbar |
256 (&H100) |
XBar (Averages) |
CCGraph1XMed |
512 (&H200) |
Median |
CCGraph1Ix |
768 (&H300) |
Individual X |
CCGraph1Ma |
1024 (&H400) |
Moving Average |
CCGraph1Pc |
1280 (&H500) |
Pre-Control |
CCGraph1Ppt |
2048 (&H800) |
Parts per Thousand |
CCGraph1Dpto |
2304 (&H900) |
Defects per Thousand Opportunities |
CCGraph1Ppm |
2560 (&HA00) |
Part per Million |
CCGraph1Dpmo |
2816 (&HB00) |
Defects per Million Opportunities |
CCGraph1Np |
3072 (&HC00) |
Np |
CCGraph1P |
3328 (&HD00) |
P |
CCGraph1C |
3584 (&HE00) |
C |
CCGraph1U |
3840 (&HF00) |
U |
Graph 2 Chart Type
Name | Value | Comments |
---|---|---|
CCGraph2Mask |
240 (&HF0) |
Masks out the bits used to define Graph 2 of the control chart. |
CCGraph2Range |
16 (&H10) |
Range |
CCGraph2Sd |
32 (&H20) |
Standard Deviation |
CCGraph2Mr |
48 (&H30) |
Moving Range |
CCGraph2Cv |
64 (&H40) |
Covariance |
Graph 3 Chart Type
Name | Value | Comments |
---|---|---|
CCGraph3Mask |
15 (&HF) |
Masks out the bits used to define Graph 3 of the control chart. |
CCGraph3Range |
1 |
Range Within |
CCGraph3Sd |
2 |
Standard Deviation Within |
Chart Processing Option Values
Name | Value | Comments |
---|---|---|
CCProcMask |
61440 (&HF000) |
Masks out the bits used to define the control chart's processing options. |
CCProcTraditional |
0 |
Standard |
CCProcNominal |
4096 (&H1000) |
Nominal |
CCProcTarget |
8192 (&H2000) |
Target |
CCProcShortrun |
12288 (&H3000) |
Short Run |
CCProcZed |
16384 (&H4000) |
Z |
CCProcProcessMean |
20480 (&H5000) |
Process Mean |
ConnectionTypes
When making a database connection with the database object, the various values can be combined and passed into the Connect function (See Connect Function).
Name | Value | Comments |
---|---|---|
DBConnect_ShowDialog |
256 (&H100) |
Display the Select InfinityQS Data Source dialog box event if DSN is specified. |
DBConnect_SPCUser |
1 |
Log in using SPC security privileges. This setting will also affect HasPrivileges (See HasPrivilege Function). |
DBConnect_GTSUser |
2 |
Log in using GTS security privileges. |
DBConnect_MSAUser |
4 |
Log in using MSA security privileges. |
DBConnect_SystemUser |
255 (&HFF) |
Log in using System security privileges. |
DatabaseAccessErrorConstants
The following values are used with the PostError function (See PostErrors Function)
Name | Value | Comments |
---|---|---|
PostNoErrors |
0 |
Suppress the display of warnings and critical errors |
PostErrorsOnly |
1 |
Display only critical errors |
PostWarningsOnly |
2 |
Display only warnings |
PostAllErrors |
15 |
Display both warning and critical errors |
LogNoErrors |
0 |
Suppress the logging of warnings and critical errors |
LogErrorsOnly |
4096 (&H1000) |
Log only critical errors |
LogWarningsOnly |
8192 (&H2000) |
Log only warning errors |
LogAll |
-4096 (&HFFFFF000) |
Log both warning and critical errors |
DatabaseAddConstants
Reserved
Name | Value | Comments |
---|---|---|
NoAutomaticID |
536870912 (&H20000000) |
Override the automatic primary key assignment |
NoAutomaticDate |
1073741824 (&H40000000) |
Override the automatic create time and edit time assignments |
DatabaseConnectOptionConstants
No longer supported
Name | Value | Comments |
---|---|---|
NoResolveNoPrompt |
0 |
Obsolete |
ResolveNoPrompt |
1 |
Obsolete |
PromptNoResolve |
2 |
Obsolete |
ResolvePrompt |
3 |
Obsolete |
DatabaseErrorConstants
No longer supported
Name | Value | Comments |
---|---|---|
InvalidReference |
-2147221503 (&H80040001) |
Database object has not been instantiated |
InvalidTask |
-2147221502 (&H80040002) |
Unable to obtain or set an internal database task handle. Database object may not be authenticated. |
Connected |
-2147221501 (&H80040003) |
Unable to Connect |
InvalidDB |
-2147221500 (&H80040004) |
Invalid Database specified. DSN may be invalid. |
AlreadyConnected |
-2147221499 (&H80040005) |
Already connected and unable to automatically disconnect and reconnect at this time. |
NoRecordsFound |
-2147221498 (&H80040006) |
Unable to find record. |
NoDatabaseError |
0 |
No error occurred. |
DatabaseInformationEnums
Reserved
Name | Value | Comments |
---|---|---|
DI_DataSource |
1 |
Reserved |
DI_Driver |
2 |
Reserved |
DI_User |
3 |
Reserved |
GI_LNAME |
4 |
Reserved |
DI_Password |
5 |
Reserved |
GI_SECU |
6 |
Reserved |
GI_EMPL |
7 |
Reserved |
GI_ODBCVERSION |
8 |
Reserved |
GI_DRIVERVER |
9 |
Reserved |
GI_DBMSNAME |
10 |
Reserved |
GI_DBMSVER |
11 |
Reserved |
GI_DATABASENAME |
12 |
Reserved |
GI_APP |
13 |
Reserved |
DI_ConnectionString |
14 |
Reserved |
GI_ABOUT_DS |
1000 (&H3E8) |
Reserved |
EvntInfTypConstants
The following values are used with the EvntInf.Typ property to describe the type of process event. (See Typ Property.)
Name | Value | Comments |
---|---|---|
Undefined |
0 |
Process Event has not been assigned a specific type |
OutOfControl |
1 |
Process Event was created due to a subgroup alarm violation |
General |
2 |
Process Event was created manually by a user |
SamplingViolation |
3 |
Process Event occurred because an expected subgroup collection did not take place |
SubgroupDisable |
4 |
Process Event was written because a subgroup was disabled |
SubgroupDelete |
5 |
Process Event was written because a subgroup was deleted |
SubgroupEdit |
6 |
Process Event was written because a subgroup was edited |
FieldTypes
Reserved
Name | Value | Comments |
---|---|---|
FieldTypeCharacter |
0 |
Reserved |
FieldTypeInteger |
1 |
Reserved |
FieldtypeLong |
2 |
Reserved |
FieldTypeSingle |
3 |
Reserved |
FindOptions
Reserved
Name | Value | Comments |
---|---|---|
FindOptions_Distinct |
16 (&H10) |
Reserved |
GageInfActvConstants
The following values apply to the GageInf.Actv property. (See Actv Property.)
Name | Value | Comments |
---|---|---|
Active |
0 |
The gage is currently active and ready for use. |
Inactive |
1 |
The gage is not currently available for use. |
Repair |
2 |
The gage is currently being, or needs to be repaired. |
Calibrate |
3 |
The gage is currently being, or needs to be calibrated. |
SecurityPrivilegeTypes
The following values represent security privileges. They can be grouped into 4 categories. When using HasPrivileges (See HasPrivilege Function), only one of the categories apply depending on how the database connection was made (See Connect Function).
However, all constants below can be evaluated if applicable Role has been acquired for the ConnectedEmployee (See ConnectedEmployee Function).
System Privileges are evaluated against the Sys property (See Sys Property).
Name | Value | Comments |
---|---|---|
SystemUser |
1 |
This bit grants a user access to system tools such as Database Manager. |
SystemTableAdd |
2 |
This bit allows a user to add records to the database. |
SystemTableEdit |
4 |
This bit allows a user to modify existing records. |
SystemTableDelete |
8 |
This bit allows a user to delete records. |
SystemDataselectDelete |
16 (&H10) |
This bit allows the user to delete subgroups and process events using the Data Selection Utility of Database Manager. |
SystemDatabaseInitialize |
32 (&H20) |
This bit allows the user to Initialize all InfinityQS tables. |
SystemRebuildKeys |
64 (&H40) |
This bit allows the user to rebuild InfinityQS table constraints. |
SystemAddEmployee |
128 (&H80) |
This bit allows a user to add new employees. |
SystemEditEmployee |
256 (&H100) |
This bit allows a user to modify existing employees. |
SystemDeleteEmployee |
512 (&H200) |
This bit allows a user to delete employees. |
SystemEditEmployeeSecurity |
1024 (&H400) |
This bit allows a user to modify user accounts. |
SPC Privileges are evaluated against the SpcApp property (See SpcApp Property).
Name | Value | Comments |
---|---|---|
SPCUser |
1 |
This bit allows the user to access InfinityQS SPC. |
SPCAddSubgroup |
2 |
This bit allows the user to add subgroups. |
SPCDisableSubgroup |
4 |
This bit allows the user to disable subgroups. |
SPCEditSubgroup |
8 |
This bit allows the user to edit subgroups. |
SPCDeleteSubgroup |
16 (&H10) |
This bit allows the user to delete subgroups. |
SPCAddEvent |
32 (&H20) |
This bit allows the user to add process events. |
SPCDeleteEvent |
64 (&H40) |
This bit allows the user to delete process events. |
SPCAddEventAcc |
128 (&H80) |
This bit allows the user set assignable causes to process events. |
SPCAddEventCac |
256 (&H100) |
This bit allows the user to set correct actions to process events. |
SPCCreateProject |
512 (&H200) |
This bit allows the user to create SPC Projects. |
SPCPreferences |
1024 (&H400) |
This bit allows the user to modify SPC Preferences. |
SPCAddEditDefOpp |
2048 (&H800) |
This bit allows the user to add and modify defect opportunities. |
SPCAddEditSpecLim |
4096 (&H1000) |
This bit allows the user to add and modify specification limits. |
SPCAddEditCtrlLim |
8192 (&H2000) |
This bit allows the user to add and modify control limits. |
SPCAddEditAlarmRule |
16384 (&H4000) |
This bit allows the user to add and modify alarm rules. |
SPCAddEditEmail |
-32768 (&HFFFF8000) |
This bit allows the user to add and modify email settings. |
SPCAddEditEmployee |
65536 (&H10000) |
This bit allows the user to add and modify employees. |
SPCAddEditCompany |
131072 (&H20000) |
This bit allows the user to add and modify companies. |
SPCAddEditPart |
262144 (&H40000) |
This bit allows the user to add and modify parts. |
SPCAddEditProcess |
524288 (&H80000) |
This bit allows the user to add and modify processes. |
SPCAddEditTest |
1048576 (&H100000) |
This bit allows the user to add and modify tests. |
SPCAddEditDescriptors |
2097152 (&H200000) |
This bit allows the user to add and modify descriptors. |
SPCAddEditDefects |
4194304 (&H400000) |
This bit allows the user to add and modify defect codes. |
SPCAddEditAcc |
8388608 (&H800000) |
This bit allows the user to add and modify assignable cause codes. |
SPCAddEditCac |
16777216 (&H1000000) |
This bit allows the user to add and modify corrective action codes. |
GTS Privileges are evaluated against the GgsApp property (See GtsApp Property).
Name | Value | Comments |
---|---|---|
GTSUser |
1 |
This bit allows the user access to InfinityQS GTS. |
GTSMove |
2 |
This bit allows the user to move gages. |
GTSCalibrate |
4 |
This bit allows the user to calibrate gages. |
GTSAddGage |
8 |
This bit allows the user to add gages. |
GTSEditGage |
16 (&H10) |
This bit allows the user to modify gages. |
GTSAddEditGageType |
32 (&H20) |
This bit allows the user to add and modify gage types. |
GTSAddEditGageModel |
64 (&H40) |
This bit allows the user add and modify gage models. |
GTSAddEditProcedureRequirements |
128 (&H80) |
This bit allows the user to add and modify calibration requirements. |
GTSAddEditEmployee |
256 (&H100) |
This bit allows the user to add and modify employees. |
GTSAddEditCompany |
512 (&H200) |
This bit allows the user to add and modify companies. |
GTSAddEditLocations |
1024 (&H400) |
This bit allows the user to add and modify locations (e.g. company, department, area, cabinet and drawer) |
GTSPreferences |
2048 (&H800) |
This bit allows the user to change GTS Preferences. |
MSA Privileges are evaluated against the MsaApp property (See MsaApp Property)
Name | Value | Comments |
---|---|---|
MSAUser |
1 |
This bit allows the user to access InfinityQS MSA. |
MSAAddStudy |
2 |
This bit allows the user to add gage studies. |
MSAEditStudy |
4 |
This bit allows the user to modify gage studies. |
MSADeleteStudy |
8 |
This bit allows the user to remove gage studies. |
MSACreateProject |
16 (&H10) |
This bit allows the user to create MSA projects. |
MSAPreferences |
32 (&H20) |
This bit allows the user to modify MSA preferences. |
MSAAddEditSpecLim |
64 (&H40) |
This bit allows the user to add and modify specification limits. |
SpecLimUseConstants
The following constants represent bitwise values that specify which specification limit values can be used.
See Aflag Property and Eflag Property for more about the use of these settings.
Name | Value | Comments |
---|---|---|
UseURL |
1 |
See Url Property |
UseUSL |
2 |
See Usl Property |
UseUGB |
4 |
See Ugb Property |
UseTAR |
8 |
See Tar Property |
UseLGB |
16 (&H10) |
See Lgb Property |
UseLSL |
32 (&H20) |
See Lsl Property |
UseLRL |
64 (&H40) |
See Lrl Property |
UseUWP |
256 (&H100) |
See Uwp Property |
UseLWP |
512 (&H200) |
See Lwp Property |
UseUSG |
4096 (&H1000) |
See Usg Property |
UseLSG |
8192 (&H2000) |
See Lsg Property |
UseUDS |
65536 (&H10000) |
See Uds Property |
UseLDS |
131072 (&H20000) |
See Lds Property |
The following code example saves a specification limit whose Upper, Target and Lower limits have been enabled for use.
Dim oSpecLim As New iiaDatabase6.SpecLim
oSpecLim.Part = lngPartID
oSpecLim.Test = lngTestID
oSpecLim.Eflag = UseLSL Or UseTAR Or UseUSL
oSpecLim.Usl = dblUpper
oSpecLim.Tar = dlbTarget
oSpecLim.Lsl = dlbLower
If oSpecLim.Add(moDatabase) Then MsgBox "Success!"
Including the following line to the code example above, would further indicate that the alarms should be triggered for values above or below the Upper and Lower limits.
oSpecLim.Aflag = UseLSL Or UseUSL
SQLFlagConstants
All Field Flag properties can be assigned one or more of the following constants.
The following code example demonstrates how to find records that are equal to a specific field flag value.
oSpecLim.Part = lngPartID
oSpecLim.PartFlag = WhereEqual
Certain constants can also be combined by ORing them together. In this example, Defects with a factor value > 0 are also returned, sorted by factor value.
oDefDat.Fctr = 0
oDefDat.FctrFlag = WhereGreater Or OrderByAscending
The following list shows each field flag constant and briefly describes its responsibility. See Field Flag Properties for more about using these contants.
Name | Value | Responsibility | Comments |
---|---|---|---|
NoSQLFlags |
0 |
None |
No field flag setting. |
WhereEqual |
1 |
Filtering |
Locate records equal to this field property's value. |
WhereGreater |
2 |
Filtering |
Locate records greater than this field property's value. |
WhereGreaterEqual |
3 |
Filtering |
Locate records greater than or equal to this field property's value. |
WhereLess |
4 |
Filtering |
Locate records less than this field property's value. |
WhereLessEqual |
5 |
Filtering |
Locate records less than or equal to this field property's value. |
WhereNotEqual |
6 |
Filtering |
Locate records not equal to this field property's value. |
WhereBitSet |
8 |
Filtering |
Not supported. |
WhereBetween |
9 |
Filtering |
Not supported. |
ReturnField |
16 (&H10) |
N/A |
Not supported. |
UpdateField |
32 (&H20) |
Updating |
Use this field property's value when Editing existing records. |
ReturnItemData |
64 (&H40) |
N/A |
Not supported. |
OrderByAscending |
256 (&H100) |
Sorting |
Return records ordered by this field in ascending order. |
OrderByDescending |
512 (&H200) |
Sorting |
Return records ordered by this field in descending order. |
TableConstants
Reserved
Name | Value | Comments |
---|---|---|
AccDatIndex |
5 |
Reserved |
AccFailIndex |
0 |
Reserved |
AccGrpIndex |
6 |
Reserved |
AccLinkIndex |
68 (&H44) |
Reserved |
AccLinkVIndex |
69 (&H45) |
Reserved |
AccLogIndex |
1 |
Reserved |
AlrRuleIndex |
2 |
Reserved |
AreaInfIndex |
4 |
Reserved |
CacDatIndex |
12 |
Reserved |
CacGrpIndex |
13 |
Reserved |
CalCmtIndex |
7 |
Reserved |
CalDatIndex |
8 |
Reserved |
CalInfIndex |
9 |
Reserved |
CoInfIndex |
10 |
Reserved |
CtrlLimIndex |
11 |
Reserved |
CtrlSgrpIndex |
70 (&H46) |
Reserved |
DbInfIndex |
14 |
Reserved |
DefDatIndex |
16 (&H10) |
Reserved |
DefGrpIndex |
17 (&H11) |
Reserved |
DefOppIndex |
15 |
Reserved |
DeptInfIndex |
18 (&H12) |
Reserved |
DescDatIndex |
20 (&H14) |
Reserved |
DescGrpIndex |
19 (&H13) |
Reserved |
DivInfIndex |
84 (&H54) |
Reserved |
EmplInfIndex |
22 (&H16) |
Reserved |
EmplPchIndex |
23 (&H17) |
Reserved |
EmplSecIndex |
24 (&H18) |
Reserved |
EmplXtrIndex |
21 (&H15) |
Reserved |
EvntCmtIndex |
25 (&H19) |
Reserved |
EvntInfIndex |
26 (&H1A) |
Reserved |
GageInfIndex |
27 (&H1B) |
Reserved |
GageLocIndex |
28 (&H1C) |
Reserved |
GageMdlIndex |
29 (&H1D) |
Reserved |
GageMovIndex |
31 (&H1F) |
Reserved |
GageRefIndex |
32 (&H20) |
Reserved |
GageTypIndex |
38 (&H26) |
Reserved |
GmdlRefIndex |
30 (&H1E) |
Reserved |
GrrCmtIndex |
33 (&H21) |
Reserved |
GrrDatIndex |
34 (&H22) |
Reserved |
GrrExtIndex |
35 (&H23) |
Reserved |
GrrInfIndex |
36 (&H24) |
Reserved |
GrrSumIndex |
37 (&H25) |
Reserved |
JobDatIndex |
39 (&H27) |
Reserved |
JobDscIndex |
40 (&H28) |
Reserved |
JobGrpIndex |
41 (&H29) |
Reserved |
JobOpIndex |
77 (&H4D) |
Reserved |
JobOpDscIndex |
80 (&H50) |
Reserved |
JobOpLotIndex |
79 (&H4F) |
Reserved |
JobOpPrcsIndex |
78 (&H4E) |
Reserved |
JobSumIndex |
42 (&H2A) |
Reserved |
LngDatIndex |
43 (&H2B) |
Reserved |
LngTypIndex |
44 (&H2C) |
Reserved |
LotAcReqIndex |
82 (&H52) |
Reserved |
LotAcSumIndex |
83 (&H53) |
Reserved |
LotSumIndex |
74 (&H4A) |
Reserved |
MeasTypIndex |
45 (&H2D) |
Reserved |
NetInfIndex |
86 (&H56) |
Reserved |
PartDatIndex |
47 (&H2F) |
Reserved |
PartGrpIndex |
46 (&H2E) |
Reserved |
PartLotIndex |
73 (&H49) |
Reserved |
PartRevIndex |
81 (&H51) |
Reserved |
PartSnIndex |
48 (&H30) |
Reserved |
PartTestIndex |
90 (&H5A) |
Reserved |
PrcdDatIndex |
49 (&H31) |
Reserved |
PrcdInfIndex |
50 (&H32) |
Reserved |
PrcsDatIndex |
52 (&H34) |
Reserved |
PrcsGrpIndex |
51 (&H33) |
Reserved |
PrcsUntIndex |
88 (&H58) |
Reserved |
RequDatIndex |
53 (&H35) |
Reserved |
RequInfIndex |
54 (&H36) |
Reserved |
RfcCodeIndex |
72 (&H48) |
Reserved |
RfcInfIndex |
71 (&H47) |
Reserved |
RuleDefIndex |
3 |
Reserved |
SecuInfIndex |
55 (&H37) |
Reserved |
SecuXtrIndex |
76 (&H4C) |
Reserved |
SgrpCmtIndex |
60 (&H3C) |
Reserved |
SgrpDscIndex |
62 (&H3E) |
Reserved |
SgrpExtIndex |
61 (&H3D) |
Reserved |
SgrpInfIndex |
63 (&H3F) |
Reserved |
SgrpLotIndex |
75 (&H4B) |
Reserved |
SgrpTstIndex |
64 (&H40) |
Reserved |
ShftDatIndex |
56 (&H38) |
Reserved |
ShftGrpIndex |
57 (&H39) |
Reserved |
SiteInfIndex |
85 (&H55) |
Reserved |
SpcMailIndex |
58 (&H3A) |
Reserved |
SpecLimIndex |
59 (&H3B) |
Reserved |
TestDatIndex |
66 (&H42) |
Reserved |
TestGrpIndex |
65 (&H41) |
Reserved |
UnitTypIndex |
67 (&H43) |
Reserved |
WkstInfIndex |
87 (&H57) |
Reserved |
WkstXtrIndex |
89 (&H59) |
Reserved |
TableTypes
Reserved
Name | Value | Comments |
---|---|---|
TableTypeStandard |
0 |
Reserved |
TableTypeAudit |
1 |
Reserved |
TableTypeArchive |
2 |
Reserved |
TableTypeMask |
15 |
Reserved |
TestDatTypeConstants
The following values apply to the TestDat.Typ property. See Typ Property.
Name | Value | Comments |
---|---|---|
Variable |
1 |
Test values that represent real numbers and are monitored using Variable control charts |
Defects |
2 |
Test values that represent integer number and are monitored using C and U attribute control charts. |
Defectives |
4 |
Test values that represent integer numbers and are monitored using NP and P attribute control charts. |