peach info Homepage
Forum Home Forum Home > INTEGRATION & ADDONS > Useful Utilities
  New Posts New Posts
  FAQ FAQ  Forum Search   Register Register  Login Login

PBS Email Query Executable

 Post Reply Post Reply
Author
Message Reverse Sort Order
peach View Drop Down
Admin Group
Admin Group

THE BOSS

Joined: 01-Jan-2006
Status: Offline
Points: 1295
Post Options Post Options   Thanks (0) Thanks(0)   Quote peach Quote  Post ReplyReply Direct Link To This Post Topic: PBS Email Query Executable
    Posted: 08-Aug-2014 at 12:14

Attached is an application that lets you store a query which when run if it returns any records, it will send an email (setup email details in the email tab first)
Extract into its own folder,  C:\PBSEmailQuery

Example: If you wanted to check for new online orders every 5 minutes and email you each time an online order was received...... Query e.g. would be: Select id from Pbstrans where id like 'co*' and source = 'online' and reference = 'final'

Set the database location to look at the pbo.mdb

There is a batch file in the zip too – so you can setup a scheduled task to run every 10 mins.


http://www.peachinfo.net/downloads/PBSEmailQuery_v1.1.zip






Edited by peach - 08-Aug-2014 at 12:17
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 11.04
Copyright ©2001-2015 Web Wiz Ltd.

This page was generated in 0.078 seconds.