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:

  1. Begin or open an existing project
  2. 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.

  1. Add a Module (BAS) to the project and enter the following code sample.
  2. 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

  3. Run the program.
  4. The Select Data Source dialog is presented. Choose any ProFicient data source.
  5. 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.
  6. If connected successfully, Form1 will display normally. Otherwise an error is displayed and the application ends.

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.

  1. 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.)
  2. 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

  3. Run the program and click the Login button.
  4. 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.
  5. A message box will indicate whether the connection was established successfully or not.

    Expected Result

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

AccDat Object

Assignable Cause Code

ACC_DAT

AccFail Object

Access Failure Log

ACC_FAIL

AccGrp Object

Assignable Cause Group

ACC_GRP

AccLink Object

Assignable Cause Linkage

ACC_LINK

AccLinkV Object

Assignable Cause Linkage View

ACC_LINK_V

AccLog Object

Access Log

ACC_LOG

AlrRule Object

Alarm Rule Assignments

ALR_RULE

AreaInf Object

Area Information

AREA_INF

CacDat Object

Corrective Action Code

CAC_DAT

CacGrp Object

Corrective Action Group

CAC_GRP

CalCmt Object

Calibration Comments

CAL_CMT

CalDat Object

Calibration Data

CAL_DAT

CalInf Object

Calibration Information

CAL_INF

CoInf Object

Company Information

CO_INF

CtrlLim Object

Control Limits

CTRL_LIM

CtrlSgrp Object

Control Limit Subgroups

CTRL_SGRP

DbInf Object

Database Information

DB_INF

DefDat Object

Defect/Defective Code

DEF_DAT

DefGrp Object

Defect/Defective Group

DEF_GRP

DefOpp Object

Defect Opportunities

DEF_OPP

DeptInf Object

Department Information

DEPT_INF

DescDat Object

Descriptor

DESC_DAT

DescGrp Object

Descriptor Category

DESC_GRP

DivInf Object

Division Information

DIV_INF

EmplInf Object

Employee Information

EMPL_INF

EmplPch Object

Employee Password History

EMPL_PCH

EmplSec Object

Employee Security

EMPL_SEC

EmplXtr Object

Employee Extra

EMPL_XTR

EvntCmt Object

Event Notes

EVNT_CMT

EvntInf Object

Event Information

EVNT_INF

GageInf Object

Gage Information

GAGE_INF

GageLoc Object

Gage Location (View)

GAGE_LOC

GageMdl Object

Gage Model

GAGE_MDL

GageMov Object

Gage Movement

GAGE_MOV

GageRef Object

Gage Reference

GAGE_REF

GageTyp Object

Gage Type

GAGE_TYP

GageRef Object

Gage Model Reference

GMDL_REF

GrrCmt Object

Gage Study Comments

GRR_CMT

GrrDat Object

Gage Study Data

GRR_DAT

GrrExt Object

Gage Study Data (View)

GRR_EXT

GrrInf Object

Gage Study Information

GRR_INF

GrrSum Object

Gage Study Summary

GRR_SUM

JobDat Object

Job

JOB_DAT

JobDsc Object

Job Descriptors

JOB_DSC

JobGrp Object

Job Group

JOB_GRP

JobOp Object

Job Operation

JOB_OP

JobOpDsc Object

Job Operation Descriptors

JOB_OP_DSC

JobOpLot Object

Job Operation Lot

JOB_OP_LOT

JobOpPrcs Object

Job Operation Process

JOB_OP_PRCS

JobSum Object

Job Summary

JOB_SUM

LngDat Object

Language Resource

LNG_DAT

LngTyp Object

Language Type

LNG_TYP

LotAcReq Object

Lot Acceptance Sampling Requirements

LOT_AC_REQ

LotAcSum Object

Lot Acceptance Sampling Summary

LOT_AC_SUM

LotSum Object

Lot Summary

LOT_SUM

MeasTyp Object

Measurement Type

MEAS_TYP

NetInf Object

Network Information

NET_INF

PartDat Object

Part

PART_DAT

PartGrp Object

Part Group

PART_GRP

PartLot Object

Lot

PART_LOT

PartSn Object

Part Serial Number

PART_SN

PartTest Object

Part/Test Information

PART_TEST

PrcdDat Object

Procedure Data

PRCD_DAT

PrcdInf Object

Procedure Information

PRCD_INF

PrcsDat Object

Process

PRCS_DAT

PrcsGrp Object

Process Group

PRCS_GRP

PrcsUnt Object

Process Unit

PRCS_UNT

RequDat Object

Requirement Data

REQU_DAT

RequInf Object

Requirement Information

REQU_INF

RfcCode Object

Reason for Change Code

RFC_CODE

RfcInf Object

Reason for Change

RFC_INF

RuleDef Object

Alarm Rule Definitions

RULE_DEF

SecuInf Object

Role Information

SECU_INF

SecuXtr Object

Role Extra

SECU_XTR

SgrpCmt Object

Subgroup Comments

SGRP_CMT

SgrpDsc Object

Subgroup Descriptors

SGRP_DSC

SgrpExt Object

Subgroup Data (View)

SGRP_EXT

SgrpInf Object

Subgroup Information

SGRP_INF

SgrpLot Object

Subgroup Component Lots

SGRP_LOT

SgrpTst Object

Subgroup Tests

SGRP_TST

ShftDat Object

Shift

SHFT_DAT

ShftGrp Object

Shift Group

SHFT_GRP

SiteInf Object

Site Information

SITE_INF

SpcMail Object

SPC Email Notification

SPC_MAIL

SpecLim Object

Specification Limits

SPEC_LIM

TestDat Object

Tests/Features

TEST_DAT

TestGrp Object

Test/Feature Group

TEST_GRP

UnitTyp Object

Unit Type

UNIT_TYP

WkstInf Object

Workstation Information

WKST_INF

WkstXtr Object

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.

  1. 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.)
  2. 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).
  3. 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.

  1. Most importantly, consult the table definitions to verify no constraints will be violated.
  2. The Field defined as Primary, but not Foreign (as noted within the Table Definitions), cannot be modified.
  3. 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.
  4. 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.

  1. Most importantly, consult the table definitions to verify no constraints will be violated. This method supports cascade deletes.
  2. 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.

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

Size Property (Integer)

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 PropertyCount 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

Find Function (Table Objects)

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

AccDat Object, EvntInf Object

Accd Property

This property returns or sets an Access Code value.

Syntax

lngValue = object.Accd

object.Accd = lngValue

Return Value

Long

Related Objects

AccFail Object, AccLog Object

AccdFlag Property

See Field Flag Properties.

Syntax

lngValue = object.AccdFlag

object.AccdFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

AccFail Object, AccLog Object

AccFlag Property

See Field Flag Properties.

Syntax

lngValue = object.AccFlag

object.AccFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

AccDat Object, EvntInf Object

Accu Property

This property returns or sets Gage Model Accuracy.

Syntax

dblValue = object.Accu

object.Accu = dblValue

Return Value

Double

Related Objects

GageMdl Object

AccuFlag Property

See Field Flag Properties.

Syntax

lngValue = object.AccuFlag

object.AccuFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

GageMdl Object

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

EvntInf Object

AcemFlag Property

See Field Flag Properties.

Syntax

lngValue = object.AcemFlag

object.AcemFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

EvntInf Object

Acfl Property

This property returns or sets the Access Failure record ID.

Syntax

lngValue = object.Acfl

object.Acfl = lngValue

Return Value

Long

Related Objects

AccFail Object

AcflFlag Property

See Field Flag Properties.

Syntax

lngValue = object.AcflFlag

object.AcflFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

AccFail Object

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

AccLog Object

AclgFlag Property

See Field Flag Properties.

Syntax

lngValue = object.AclgFlag

object.AclgFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

AccLog Object

Aclv Property

Syntax

lngValue = object.Aclv

object.Aclv = lngValue

Return Value

Long

Related Objects

SecuInf Object

AclvFlag Property

Syntax

lngValue = object.AclvFlag

object.AclvFlag = lngValue

Return Value

SQLFlagConstants

Related Objects

SecuInf Object

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

SecuInf Object

AdmnFlag Property

See Field Flag Properties.

Syntax

lngValue = object.AdmnFlag

object.AdmnFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

SecuInf Object

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

SpecLim Object

AflagFlag Property

See Field Flag Properties.

Syntax

lngValue = object.AflagFlag

object.AflagFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

SpecLim Object

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

AlrRule Object

AlrFlag Property

See Field Flag Properties.

Syntax

lngValue = object.AlrFlag

object.AlrFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

AlrRule Object

Alrm Property

This property returns or sets an Alarm Rule record ID.

Syntax

lngValue = object.Alrm

object.Alrm = lngValue

Return Value

Long

Related Objects

AlrRule Object

AlrmFlag Property

See Field Flag Properties.

Syntax

lngValue = object.AlrmFlag

object.AlrmFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

AlrRule Object

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

AccFail Object, AccLog Object

ApcdFlag Property

See Field Flag Properties.

Syntax

lngValue = object.ApcdFlag

object.ApcdFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

AccFail Object, AccLog Object

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

GrrExt Object, GrrSum Object

AvFlag Property

See Field Flag Properties.

Syntax

lngValue = object.AvFlag

object.AvFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

GrrExt Object, GrrSum Object

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

CalInf Object

BarFlag Property

See Field Flag Properties.

Syntax

lngValue = object.BarFlag

object.BarFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

CalInf Object

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

CacDat Object, EvntInf Object

CacFlag Property

See Field Flag Properties.

Syntax

lngValue = object.CacFlag

object.CacFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

CacDat Object, EvntInf Object

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

EvntInf Object

CaemFlag Property

See Field Flag Properties.

Syntax

lngValue = object.CaemFlag

object.CaemFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

EvntInf Object

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

EvntInf Object

CatmFlag Property

See Field Flag Properties.

Syntax

lngValue = object.CatmFlag

object.CatmFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

EvntInf Object

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

PartLot Object

CcpntFlag Property

See Field Flag Properties.

Syntax

lngValue = object.CcpntFlag

object.CcpntFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

PartLot Object

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

AlrRule Object

ChrtFlag Property

See Field Flag Properties.

Syntax

lngValue = object.ChrtFlag

object.ChrtFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

AlrRule Object

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

CalDat Object, RequDat Object

ClnoFlag Property

See Field Flag Properties.

Syntax

lngValue = object.ClnoFlag

object.ClnoFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

CalDat Object, RequDat Object

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

JobOp Object, PartLot Object

ClosedFlag Property

See Field Flag Properties.

Syntax

lngValue = object.ClosedFlag

object.ClosedFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

JobOp Object, PartLot Object

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

SgrpLot Object

ClotFlag Property

See Field Flag Properties.

Syntax

lngValue = object.ClotFlag

object.ClotFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

SgrpLot Object

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

SpecLim Object

CpFlag Property

See Field Flag Properties.

Syntax

lngValue = object.CpFlag

object.CpFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

SpecLim Object

Cpk Property

This property returns or sets the Cpk (a capability index).

Syntax

dblValue = object.Cpk

object.Cpk = dblValue

Return Value

Double

Related Objects

SpecLim Object

CpkFlag Property

See Field Flag Properties.

Syntax

lngValue = object.CpkFlag

object.CpkFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

SpecLim Object

Cpu Property

This property returns or sets a computer name.

Syntax

strValue = object.Cpu

object.Cpu = strValue

Return Value

String

Related Objects

AccFail Object, AccLog Object

CpuFlag Property

See Field Flag Properties.

Syntax

lngValue = object.CpuFlag

object.CpuFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

AccFail Object, AccLog Object

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

PartLot Object

CtestFlag Property

See Field Flag Properties.

Syntax

lngValue = object.CtestFlag

object.CtestFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

PartLot Object

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

DatabaseInformation Object

Related Objects

Database Object

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

DefOpp Object

DfopFlag Property

See Field Flag Properties.

Syntax

lngValue = object.DfopFlag

object.DfopFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

DefOpp Object

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

Database Object

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

CalInf Object

EltmFlag Property

See Field Flag Properties.

Syntax

lngValue = object.EltmFlag

object.EltmFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

CalInf Object

Email Property

This property returns or sets an email address.

Syntax

strValue = object.Email

object.Email = strValue

Return Value

String

Related Objects

EmplInf Object

EmailFlag Property

See Field Flag Properties.

Syntax

lngValue = object.EmailFlag

object.EmailFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

EmplInf Object

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

EmplInf Object

Related Objects

SPCMailRecipient Object

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

EmplInf Object

EpidFlag Property

See Field Flag Properties.

Syntax

lngValue = object.EpidFlag

object.EpidFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

EmplInf Object

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

GrrExt Object, GrrSum Object

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

JobSum Object, LotSum Object

EvctFlag Property

See Field Flag Properties.

Syntax

lngValue = object.EvctFlag

object.EvctFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

JobSum Object, LotSum Object

EvFlag Property

See Field Flag Properties.

Syntax

lngValue = object.EvFlag

object.EvFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

GrrExt Object, GrrSum Object

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

EvntInf Object

EvtmFlag Property

See Field Flag Properties.

Syntax

lngValue = object.EvtmFlag

object.EvtmFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

EvntInf Object

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

TableDefinition Object

FieldType Property

Not Supported. Reserved for Internal Use.

Syntax

lngValue = object.FieldType

Return Value

FieldTypes

Related Objects

FieldDefinition Object

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

CalDat Object

FinlFlag Property

See Field Flag Properties.

Syntax

lngValue = object.FinlFlag

object.FinlFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

CalDat Object

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

SpecLim Object

FitFlag Property

See Field Flag Properties.

Syntax

lngValue = object.FitFlag

object.FitFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

SpecLim Object

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

GageMdl Object

FixedFlag Property

See Field Flag Properties.

Syntax

lngValue = object.FixedFlag

object.FixedFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

GageMdl Object

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

FieldDefinition Object

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

GageMov Object

GmidFlag Property

See Field Flag Properties.

Syntax

lngValue = object.GmidFlag

object.GmidFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

GageMov Object

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

GrrExt Object, GrrSum Object

GrrFlag Property

See Field Flag Properties.

Syntax

lngValue = object.GrrFlag

object.GrrFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

GrrExt Object, GrrSum Object

Grsn Property

This property returns or sets a Gage Reference Serial Number.

Syntax

strValue = object.Grsn

object.Grsn = strValue

Return Value

String

Related Objects

GageRef Object

GrsnFlag Property

See Field Flag Properties.

Syntax

lngValue = object.GrsnFlag

object.GrsnFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

GageRef Object

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

SecuInf Object

GtsAppFlag Property

See Field Flag Properties.

Syntax

lngValue = object.GtsAppFlag

object.GtsAppFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

SecuInf Object

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

RuleDef Object

HitsFlag Property

See Field Flag Properties.

Syntax

lngValue = object.HitsFlag

object.HitsFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

RuleDef Object

Hmdy Property

This property returns or sets a Humidity value.

Syntax

dblValue = object.Hmdy

object.Hmdy = dblValue

Return Value

Double

Related Objects

CalInf Object

HmdyFlag Property

See Field Flag Properties.

Syntax

lngValue = object.HmdyFlag

object.HmdyFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

CalInf Object

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

JobDat Object, PartLot Object

HoldFlag Property

See Field Flag Properties.

Syntax

lngValue = object.HoldFlag

object.HoldFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

JobDat Object, PartLot Object

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

Database Object

Id Property

Syntax

lngValue = object.Id

object.Id = lngValue

Return Value

Long

Related Objects

DbInf Object, PartTest Object

IdFlag Property

Syntax

lngValue = object.IdFlag

object.IdFlag = lngValue

Return Value

SQLFlagConstants

Related Objects

DbInf Object, PartTest Object

Index Property

Syntax

lngValue = object.Index

object.Index = lngValue

Return Value

Long

Related Objects

PartTest Object

IndexFlag Property

Syntax

lngValue = object.IndexFlag

object.IndexFlag = lngValue

Return Value

SQLFlagConstants

Related Objects

PartTest Object

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

CalDat Object

InitFlag Property

See Field Flag Properties.

Syntax

lngValue = object.InitFlag

object.InitFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

CalDat Object

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

Database Object

IsTimeField Property

Unsupported. Reserved for internal use.

Syntax

boolValue = object.IsTimeField

Return Value

Boolean

Related Objects

FieldDefinition Object

Jbds Property

This property returns or sets a Job Descriptor record ID.

Syntax

lngValue = object.Jbds

object.Jbds = lngValue

Return Value

Long

Related Objects

JobDsc Object

JbdsFlag Property

See Field Flag Properties.

Syntax

lngValue = object.JbdsFlag

object.JbdsFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

JobDsc Object

Jbgp Property

This property returns or sets a Job Group record ID.

Syntax

lngValue = object.Jbgp

object.Jbgp = lngValue

Return Value

Long

Related Objects

JobDat Object, JobGrp Object

JbgpFlag Property

See Field Flag Properties.

Syntax

lngValue = object.JbgpFlag

object.JbgpFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

JobDat Object, JobGrp Object

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

JobSum Object

JbsmFlag Property

See Field Flag Properties.

Syntax

lngValue = object.JbsmFlag

object.JbsmFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

JobSum Object

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

JobOpDsc Object

JodsFlag Property

Syntax

lngValue = object.JodsFlag

object.JodsFlag = lngValue

Return Value

SQLFlagConstants

Related Objects

JobOpDsc Object

Jolt Property

Syntax

lngValue = object.Jolt

object.Jolt = lngValue

Return Value

Long

Related Objects

JobOpLot Object

JoltFlag Property

Syntax

lngValue = object.JoltFlag

object.JoltFlag = lngValue

Return Value

SQLFlagConstants

Related Objects

JobOpLot Object

Jopr Property

Syntax

lngValue = object.Jopr

object.Jopr = lngValue

Return Value

Long

Related Objects

JobOpPrcs Object

JoprFlag Property

Syntax

lngValue = object.JoprFlag

object.JoprFlag = lngValue

Return Value

SQLFlagConstants

Related Objects

JobOpPrcs Object

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

CalInf Object, GageMdl Object

LabFlag Property

See Field Flag Properties.

Syntax

lngValue = object.LabFlag

object.LabFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

CalInf Object, GageMdl Object

Lasr Property

Syntax

lngValue = object.Lasr

object.Lasr = lngValue

Return Value

Long

Related Objects

LotAcReq Object

LasrFlag Property

Syntax

lngValue = object.LasrFlag

object.LasrFlag = lngValue

Return Value

SQLFlagConstants

Related Objects

LotAcReq Object

Lass Property

Syntax

lngValue = object.Lass

object.Lass = lngValue

Return Value

Long

Related Objects

LotAcSum Object

LassFlag Property

Syntax

lngValue = object.LassFlag

object.LassFlag = lngValue

Return Value

SQLFlagConstants

Related Objects

LotAcSum Object

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

SpecLim Object

LdsFlag Property

See Field Flag Properties.

Syntax

lngValue = object.LdsFlag

object.LdsFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

SpecLim Object

Length Property

Unsupported. Reserved for internal use.

Syntax

strValue = object.Length

Return Value

String

Related Objects

FieldDefinition Object

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

SpecLim Object

LgbFlag Property

See Field Flag Properties.

Syntax

lngValue = object.LgbFlag

object.LgbFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

SpecLim Object

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

LngDat Object, LngTyp Object

LngFlag Property

See Field Flag Properties.

Syntax

lngValue = object.LngFlag

object.LngFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

LngDat Object, LngTyp Object

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

EmplSec Object

LockedFlag Property

See Field Flag Properties.

Syntax

lngValue = object.LockedFlag

object.LockedFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

EmplSec Object

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

SpecLim Object

LsgFlag Property

See Field Flag Properties.

Syntax

lngValue = object.LsgFlag

object.LsgFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

SpecLim Object

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

LotSum Object

LtsmFlag Property

See Field Flag Properties.

Syntax

lngValue = object.LtsmFlag

object.LtsmFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

LotSum Object

Lwp Property

This property returns or sets the Lower Within Piece limits.

Syntax

dblValue = object.Lwp

object.Lwp = dblValue

Return Value

Double

Related Objects

SpecLim Object

LwpFlag Property

See Field Flag Properties.

Syntax

lngValue = object.LwpFlag

object.LwpFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

SpecLim Object

Mail Property

This property returns or sets the SPC Mail record ID.

Syntax

lngValue = object.Mail

object.Mail = lngValue

Return Value

Long

Related Objects

SpcMail Object

MailFlag Property

See Field Flag Properties.

Syntax

lngValue = object.MailFlag

object.MailFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

SpcMail Object

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

GageMdl Object

MdlFlag Property

See Field Flag Properties.

Syntax

lngValue = object.MdlFlag

object.MdlFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

GageMdl Object

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

SecuInf Object

MsaAppFlag Property

See Field Flag Properties.

Syntax

lngValue = object.MsaAppFlag

object.MsaAppFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

SecuInf Object

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

CalDat Object, RequDat Object

MtolFlag Property

See Field Flag Properties.

Syntax

lngValue = object.MtolFlag

object.MtolFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

CalDat Object, RequDat Object

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

NetInf Object, WkstInf Object

NetFlag Property

Syntax

lngValue = object.NetFlag

object.NetFlag = lngValue

Return Value

SQLFlagConstants

Related Objects

NetInf Object, WkstInf Object

Nom Property

This property returns or sets the Nominal value.

Syntax

dblValue = object.Nom

object.Nom = dblValue

Return Value

Double

Related Objects

GageMdl Object

NomFlag Property

See Field Flag Properties.

Syntax

lngValue = object.NomFlag

object.NomFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

GageMdl Object

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

JobSum Object, LotSum Object

OorFlag Property

See Field Flag Properties.

Syntax

lngValue = object.OorFlag

object.OorFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

JobSum Object, LotSum Object

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

JobSum Object, LotSum Object

OosFlag Property

See Field Flag Properties.

Syntax

lngValue = object.OosFlag

object.OosFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

JobSum Object, LotSum Object

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

JobOp Object

OpenedFlag Property

See Field Flag Properties.

Syntax

lngValue = object.OpenedFlag

object.OpenedFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

JobOp Object

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

GrrDat Object, GrrInf Object

OperFlag Property

See Field Flag Properties.

Syntax

lngValue = object.OperFlag

object.OperFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

GrrDat Object, GrrInf Object

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

JobOp Object

OpnoFlag Property

See Field Flag Properties.

Syntax

lngValue = object.OpnoFlag

object.OpnoFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

JobOp Object

Opps Property

This property returns or sets the Defect Opportunity record ID.

Syntax

lngValue = object.Opps

object.Opps = lngValue

Return Value

Long

Related Objects

DefOpp Object

OppsFlag Property

See Field Flag Properties.

Syntax

lngValue = object.OppsFlag

object.OppsFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

DefOpp Object

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

SPCMailRecipient Object

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

LotAcSum Object

PdefFlag Property

Syntax

lngValue = object.PdefFlag

object.PdefFlag = lngValue

Return Value

SQLFlagConstants

Related Objects

LotAcSum Object

Pp Property

This property returns or sets Pp (Process Performance Index)

Syntax

dblValue = object.Pp

object.Pp = dblValue

Return Value

Double

Related Objects

JobSum Object, LotSum Object

PpFlag Property

See Field Flag Properties.

Syntax

lngValue = object.PpFlag

object.PpFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

JobSum Object, LotSum Object

Ppk Property

This property returns or sets Ppk (Process Performance Index)

Syntax

dblValue = object.Ppk

object.Ppk = dblValue

Return Value

Double

Related Objects

JobSum Object, LotSum Object

PpkFlag Property

See Field Flag Properties.

Syntax

lngValue = object.PpkFlag

object.PpkFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

JobSum Object, LotSum Object

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

FieldDefinition Object

ProcessID Property

This property returns or sets the Process record ID.

Syntax

object.ProcessID = lngValue

lngValue = object.ProcessID

Return Value

Long

Related Objects

SPCMailRecipient Object

Prty Property

Unsupported.

Syntax

lngValue = object.Prty

object.Prty = lngValue

Return Value

Long

Related Objects

RuleDef Object

PrtyFlag Property

See Field Flag Properties.

Syntax

lngValue = object.PrtyFlag

object.PrtyFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

RuleDef Object

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

CalDat Object, RequDat Object

PtolFlag Property

See Field Flag Properties.

Syntax

lngValue = object.PtolFlag

object.PtolFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

CalDat Object, RequDat Object

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

GrrExt Object, GrrSum Object

PvFlag Property

See Field Flag Properties.

Syntax

lngValue = object.PvFlag

object.PvFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

GrrExt Object, GrrSum Object

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

PartLot Object

RcpntFlag Property

See Field Flag Properties.

Syntax

lngValue = object.RcpntFlag

object.RcpntFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

PartLot Object

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

Database Object

ReferenceField Property

Unsupported

Syntax

lngValue = object.ReferenceField

Return Value

Long

Related Objects

FieldDefinition Object

ReferenceKey Property

Unsupported

Syntax

boolValue = object.ReferenceKey

Return Value

Boolean

Related Objects

FieldDefinition Object

ReferenceTable Property

Unsupported

Syntax

lngValue = object.ReferenceTable

Return Value

Long

Related Objects

FieldDefinition Object

Rej Property

Syntax

lngValue = object.Rej

object.Rej = lngValue

Return Value

Long

Related Objects

LotAcSum Object

RejFlag Property

Syntax

lngValue = object.RejFlag

object.RejFlag = lngValue

Return Value

SQLFlagConstants

Related Objects

LotAcSum Object

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

LngDat Object

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

GageMdl Object

ResFlag Property

See Field Flag Properties.

Syntax

lngValue = object.ResFlag

object.ResFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

GageMdl Object, LngDat Object

Rev Property

Syntax

lngValue = object.Rev

object.Rev = lngValue

Return Value

Long

Related Objects

SpecLim Object

RevFlag Property

Syntax

lngValue = object.RevFlag

object.RevFlag = lngValue

Return Value

SQLFlagConstants

Related Objects

SpecLim Object

RFCEnabled Property

Syntax

boolValue = object.RFCEnabled

Return Value

Boolean

Related Objects

Database Object

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

SpecLim Object

RrmarFlag Property

See Field Flag Properties.

Syntax

lngValue = object.RrmarFlag

object.RrmarFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

SpecLim Object

Rrmax Property

This property returns or sets the R&R Maximum value.

Syntax

dblValue = object.Rrmax

object.Rrmax = dblValue

Return Value

Double

Related Objects

SpecLim Object

RrmaxFlag Property

See Field Flag Properties.

Syntax

lngValue = object.RrmaxFlag

object.RrmaxFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

SpecLim Object

Rscd Property

This property returns or sets the Reason Code record ID.

Syntax

lngValue = object.Rscd

object.Rscd = lngValue

Return Value

Long

Related Objects

RfcCode Object, RfcInf Object

RscdFlag Property

See Field Flag Properties.

Syntax

lngValue = object.RscdFlag

object.RscdFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

RfcCode Object, RfcInf Object

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

EmplSec Object

RtryFlag Property

See Field Flag Properties.

Syntax

lngValue = object.RtryFlag

object.RtryFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

EmplSec Object

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

RuleDef Object

RuleFlag Property

See Field Flag Properties.

Syntax

lngValue = object.RuleFlag

object.RuleFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

RuleDef Object

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

SpecLim Object

ScalFlag Property

See Field Flag Properties.

Syntax

lngValue = object.ScalFlag

object.ScalFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

SpecLim Object

Sd_Act Property

Syntax

dblValue = object.Sd_Act

object.Sd_Act = dblValue

Return Value

Double

Related Objects

LotAcSum Object

Sd_ActFlag Property

Syntax

lngValue = object.Sd_ActFlag

object.Sd_ActFlag = lngValue

Return Value

SQLFlagConstants

Related Objects

LotAcSum Object

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

LngDat Object

SectFlag Property

See Field Flag Properties.

Syntax

lngValue = object.SectFlag

object.SectFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

LngDat Object

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

ShftDat Object

ShftFlag Property

See Field Flag Properties.

Syntax

lngValue = object.ShftFlag

object.ShftFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

ShftDat Object

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

Buffer Object

SizeFlag Property

See Field Flag Properties.

Syntax

lngValue = object.SizeFlag

object.SizeFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

JobSum Object, PartLot Object

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

SecuInf Object

SpcAppFlag Property

See Field Flag Properties.

Syntax

lngValue = object.SpcAppFlag

object.SpcAppFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

SecuInf Object

Spec Property

This property returns or sets the Specification Limits record ID.

Syntax

lngValue = object.Spec

object.Spec = lngValue

Return Value

Long

Related Objects

SpecLim Object

SpecFlag Property

See Field Flag Properties.

Syntax

lngValue = object.SpecFlag

object.SpecFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

SpecLim Object

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

CtrlLim Object

SplFlag Property

See Field Flag Properties.

Syntax

lngValue = object.SplFlag

object.SplFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

CtrlLim Object

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

CalInf Object

StkrFlag Property

See Field Flag Properties.

Syntax

lngValue = object.StkrFlag

object.StkrFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

CalInf Object

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

CtrlLim Object

SwFlag Property

See Field Flag Properties.

Syntax

lngValue = object.SwFlag

object.SwFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

CtrlLim Object

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

CtrlLim Object

SwlFlag Property

See Field Flag Properties.

Syntax

lngValue = object.SwlFlag

object.SwlFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

CtrlLim Object

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

SecuInf Object

SysFlag Property

See Field Flag Properties.

Syntax

lngValue = object.SysFlag

object.SysFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

SecuInf Object

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

Database Object

Temp Property

This property returns or sets a temperature value.

Syntax

dblValue = object.Temp

object.Temp = dblValue

Return Value

Double

Related Objects

CalInf Object

TempFlag Property

See Field Flag Properties.

Syntax

lngValue = object.TempFlag

object.TempFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

CalInf Object

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

SPCMailRecipient Object

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

GrrDat Object, GrrInf Object

TrialFlag Property

See Field Flag Properties.

Syntax

lngValue = object.TrialFlag

object.TrialFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

GrrDat Object, GrrInf Object

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

GrrExt Object, GrrSum Object

Tval Property

Returns to sets the True Value of a gage calibration.

Syntax

dblValue = object.Tval

object.Tval = dblValue

Return Value

Double

Related Objects

CalDat Object, RequDat Object

TvalFlag Property

See Field Flag Properties.

Syntax

lngValue = object.TvalFlag

object.TvalFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

CalDat Object, RequDat Object

TvFlag Property

See Field Flag Properties.

Syntax

lngValue = object.TvFlag

object.TvFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

GrrExt Object, GrrSum Object

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

SpecLim Object

UdsFlag Property

See Field Flag Properties.

Syntax

lngValue = object.UdsFlag

object.UdsFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

SpecLim Object

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

SpecLim Object

UgbFlag Property

See Field Flag Properties.

Syntax

lngValue = object.UgbFlag

object.UgbFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

SpecLim Object

UID Property

Reserved for internal use

Syntax

object.UID = strValue

Return Value

String

Related Objects

DatabaseInformation Object

Unique Property

Reserved for internal use

Syntax

boolValue = object.Unique

Return Value

Boolean

Related Objects

FieldDefinition Object

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

DatabaseInformation Object

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

Database Object

Usg Property

This property returns or sets the Upper Subgroup limit.

Syntax

dblValue = object.Usg

object.Usg = dblValue

Return Value

Double

Related Objects

SpecLim Object

UsgFlag Property

See Field Flag Properties.

Syntax

lngValue = object.UsgFlag

object.UsgFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

SpecLim Object

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

SpecLim Object

UwpFlag Property

See Field Flag Properties.

Syntax

lngValue = object.UwpFlag

object.UwpFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

SpecLim Object

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

TableDefinition Object

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

GrrExt Object, GrrSum Object

WivFlag Property

See Field Flag Properties.

Syntax

lngValue = object.WivFlag

object.WivFlag = lngValue

Return Value

See SQLFlagConstants.

Related Objects

GrrExt Object, GrrSum Object

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

Database Object

AccessCode Function

Reserved

Syntax

boolValue = object.AccessCode ([Code])

Return Value

Boolean

Arguments

Name

Data Type

Description

Code

Long

(Optional)

Related Objects

DatabaseManager Object

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

Buffer Property

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.

  1. The database component has not been licensed. This is required by the Custom Software License (CSL).
  2. There are no available slots.
  3. 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

Database Object

BuildOrder Function

Reserved

Syntax

lngValue = object.BuildOrder (TableIndex)

Return Value

Long

Arguments

Name Data Type Description

TableIndex

TableConstants

Related Objects

DatabaseManager Object

CheckConnection Function

Syntax

boolValue = object.CheckConnection ([Reconnect])

Return Value

Boolean

Arguments

Name Data Type Description

Reconnect

Boolean

(Optional)

Related Objects

Database Object

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

DatabaseManager Object

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

Database Object

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

Database Object

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

DatabaseManager Object

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

DatabaseManager Object

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

DatabaseManager Object

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

Database Object

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

DatabaseManager Object

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

DatabaseManager Object

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

Buffer Property

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

SPCMailRecipient Object

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

DatabaseInformation Object

GetFieldDefinition Function

Reserved

Syntax

Set objValue = object.GetFieldDefinition (TableIndex, Field)

Return Value

FieldDefinition Object

Arguments

Name Data Type Description

TableIndex

TableConstants

Field

Long

Related Objects

DatabaseManager Object

GetTableDefinition Function

Reserved

Syntax

Set objValue = object.GetTableDefinition (TableIndex)

Return Value

TableDefinition Object

Arguments

Name Data Type Description

TableIndex

TableConstants

See TableConstants.

Related Objects

DatabaseManager Object

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

Database Object

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

Buffer Property

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

Buffer Property

InitializeEventTables Function

Reserved

Syntax

boolValue = object.InitializeEventTables ([hWnd])

Return Value

Boolean

Arguments

Name Data Type Description

hWnd

Long

(Optional)

Related Objects

DatabaseManager Object

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

DatabaseManager Object

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

DatabaseManager Object

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

Buffer Object

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

DatabaseAccessErrorConstants

Arguments

Name Data Type Description

Value

DatabaseAccessErrorConstants

See DatabaseAccessErrorConstants

Related Objects

Database Object

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

Database Object

RFCSet Function

Syntax

boolValue = object.RFCSet (RFCID, [hWnd])

Return Value

Boolean

Arguments

Name Data Type Description

RFCID

Long

hWnd

Long

(Optional)

Related Objects

Database Object

SetData Statement

Reserved

Syntax

Call object.SetData (Value)

Arguments

Name Data Type Description

Value

String

Related Objects

DatabaseInformation Object

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

Database Object

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

Database Object

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.