Using Query Properties in CIMPLICITY

CIMPLICITY requires the use of CimEdit Basic script in order to take advantage of VisiconX SQL query properties. For example, if you want to query a ProductionEventRecords table to find all records whose severity is greater than 4, you would need to create the following two elements in your CimEdit screen:

• A VisiconX Data Control containing the following SQL command:

SELECT * FROM ProductionEventRecords WHERE ProductionEventRecords.Severity > QP1

• A text button that defines an event action for the "Mouse Down" event with the following script:

Sub OnMouseDown(x As Long, y As Long, flags As Long)

    CimGetScreen.Object.Objects.Item("MyDataControlName").OleObject.QP1 = 4

End Sub

At run time, when you click the button, the VisiconX Data control will query for only those records in the ProductionEventRecords table whose severity is greater than 4.