Contents   Introduction   Concepts   User Help   Modeler Help   Browser Help
Administrator Help   Developer Help    Utility Help   Visio   Graphical Modeler

Preparing the environment to support the SQL Queries in Calc Fields and Custom Events practical example

This involves two steps, namely creating the required node types, and creating the database and DSN.

Creating the NodeTypes

Firstly you need to create two EVA Netmodeler NodeType definitions.

 The first NodeType, called "SQLCalcTest" will be used to test SQL queries using Calc Fields. Create the NodeType definition as per the illustration below:

 The second NodeType, called "SQLZIPTest", will be used to test SQL queries using Custom Events, create it as per the example below:

Creating the Database and DSN

In order to test the SQL query facility, we need to create a new database. Use Microsoft Access and create a new database called "Garbage".

Now create a table called "Table1", and a numeric field called "Field1" and two text fields called "Field2" and "Field3". You may also populate the table with some data as illustrated below:

 Next add a table called "ZipTable" with three fields called "NodeId", "Description" and "ZipCode". All fields must be of type "Text". The illustration below shows what the table should look like.

 Now we need to create a Data Source Name, or DSN. Using your "Control Panel/Administrative Tools/ODBC Data Sources" tool, create a new Microsoft Access DSN that points to your new database called "Garbage". In this example, the DSN is also called "Garbage"