Sliding Expire Date Tutorial

I just added a second "Sliding Expiration Date" tutorial to our web site (on the Tutorial page, of course). Although the process is exactly the same in both ZP 32 and ZP SQL, the scripts are different. This will true anytime you have a script that pulls data from some database other than the currently active one. For the main Sliding Expiration Date script data is pulled from the inspection database to compare the latest inspection date with the Expire Date. As a side note, I'm mulling over several options that would build the Sliding Expiration Date option into ZP SQL so that you wouldn't need scripts at all. We'll see...

Contractor Inspection Request Beta

We are currently beta testing a new web service that will allow registered contractors to view any permits they are linked to and submit requests for inspections. New screens have been added to ZonePro SQL to review the inspection requests and accept or reject them. Contractors can see the responses to their request from the original web site. You can view a demo of this site at www.zpsql.com by choosing the Contractor site option. Try logging in with the ID "CT001003" and the password "zpdemo". This new web service will be available to all ZP SQL users who have the Contractor Module installed.

Old ZP SQL Demo Is Defunct

This past weekend all our SQL databases were moved to a new server. This means that any ZonePro SQL demo created before today won't work because it won't find the databases. I have just updated the demo file on our web page and the new version works fine.