I/Gear

The information on this page pertains to Version 6.x unless specified otherwise.
Subscribe to posts

Can not recommend any more

posted Jul 2, 2015, 2:57 PM by Darren Ash

I/Gear has fallen to far behind to recommend any more.  Other reasons include not keeping a public records of development schedule, bug database, etc.  Still to dependent on core Microsoft technologies, over priced for capabilities and many more reasons.

Testing e-mail datalink

posted Jun 27, 2011, 5:11 AM by Darren Ash

A really great, simple, SMTP server for testing with is the free PostCast server.  The free Download is located: http://www.postcastserver.com/Download/

It works really well.  It only runs when you launch it and it captures the outgoing mail where you can read it from the que.  Really helps in debugging an I/Gear email datalink before turning it loose on the network.

Trigger e-mail from query that ONLY returns data.

posted Jun 27, 2011, 4:56 AM by Darren Ash   [ updated Jun 30, 2011, 11:52 AM ]

This would consist of a database query that executes and you want to email that data if records are returned.

For the database table, create a dummy field that is a calulated value (not stored) that always resolves to 1, in this case the field name is "Mail".

For the database datalink input command you create a query and map the data to datapoints that are bound to the columns.

For the trigger, set it to custom triggering and it would look similar to the following:

{SQL Server.GetNewAlarms.TriggerColumn}(0) = 1 AND {SQL Server.GetNewAlarms.TriggerColumn}.RAWDATA.REFRESH


See attached example.

| Attachments: IGear Query Trigger.pdf IGearTestDB.sql

1-3 of 3