Last Known Inspection in Combo Reports

An extra field has been added to those pulled by the Building Combination Reports screen. The field, MAXDATE, pulls the last known inspection date for each permit. This is useful information to compare with the Expire Date field to see if a building project is truly in progress. The MAXDATE is determined by looking at all of the Last Inspect fields for each given permit and selecting the most recent one. If no inspections are recorded for a permit the field will be NULL.

Notes Field Fix

I recently discovered an odd glitch. A problem in the communication between the Windows client and the SQL Database caused memo fields to be truncated to 8000 characters. Memo fields are the fields in ZonePro that do not have length restrictions such as the many Notes fields. It is very rare that anyone typed in more than 8000 characters which is why it took such a long time to discover that the problem even existed. I found a way around the communication glitch and now all updates of memo fields are once again unlimited. For now this only applies to updates or edits, not to inserts or adds. That means when you add a new record you should not immediately type more than 8000 characters into a Notes field. Instead, Save it first and then Edit the record to add your copious notes!