Introduction

VisiconX™ is a GE Plug and Solve® solution for the iFIX® and CIMPLICITY® products. It is an easy-to-use, object-oriented development tool that makes accessing data in any type of database a snap! Its simple point-and-click interface provides the means to configure access to any database and then create an SQL query as simple or complex as necessary to retrieve the information you need. You can also create simple insert and update statements to add or change the data in a database table.

VisiconX consists of a suite of controls that can be inserted into a iFIX WorkSpace™ picture or a CIMPLICITY CimEdit screen. These controls access Microsoft's ActiveX™ Data Objects (ADO), eliminating the need to write Microsoft® Visual Basic® scripts or create a customized program to access and manipulate data. A task that previously required hours of development time is reduced to seconds!

The VisiconX SQL Wizard makes it easy for you to retrieve the precise information you need, or to add and change the data stored in a database table. The SQL Wizard helps you choose options for your statement and then builds the SQL Select, Insert, or Update statement for you. If you want, you can bypass the SQL Wizard and query the database using a stored procedure or by entering an SQL statement yourself.     

Besides making data access easier and quicker, VisiconX also enforces access to secured databases. VisiconX can use either a user name and password or the features of Windows integrated security to perform a security check. The security check must succeed before VisiconX returns any data.

iFIX users can configure SQL commands to require either Perform Only or Perform and Verify electronic signatures. Both iFIX and CIMPLICITY users can configure whether the SQL Wizard is available in run mode.

See Also