|
|
![]() |
![]() |
![]() |
|
Contents Introduction Concepts User Help Modeler Help Browser Help
|
|||
![]() |
|||
![]() |
![]() |
Preparing the environment to support the SQL Queries in Calc Fields and Custom Events practical exampleThis involves two steps, namely creating the required node types, and creating the database and DSN. Creating the NodeTypesFirstly 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 DSNIn 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"
|