iFix 6.0 - Open DataBase Connectivity (ODBC)

In today's article, we will see how to connect to our Database with iFix. As a Database Management System, I have selected PostgreSQL, as we have seen with CitectSCADA.

The first step is to install the psqlodbc Driver for PostgreSQL and configure a new Data Source. If you have any doubts, here is another example for Oracle Database.

Once we have opened our project, I created a new image, where I inserted several objects, including a button.

To edit the actions, we right-click and Edit Script is the option we are looking for.

Once opened, we can see that the scripting language of iFix is Visual Basic for Applications.

As code, we are reusing what we already had from CitectSCADA, with the difference that here we are utilizing the full power of Visual Basic for Applications.

We switch to Runtime to test our code and observe in the debugger that everything works perfectly.

The data we have in our Database for this example.

06-06-2019