Introducing PTWin

Introducing
PTWin32

Support Services
Support
Services

Downloads
Downloads

User Tips
User Tips

Contact Us
Contact Us

Introducing PTWin
Home

  PTWin User Tips / DATA MODEL  Data Model

Pushing the Post Button

Saving space
Reducing a name to a number
How to look up Checklist, Inspection, and Permit Type values.

Tip #: 3.4.70
Ver(s):PTWin32, V2, V1

There are certain names in PTWin32 that are converted to numeric codes in order to save space and increase the performance of the software.

Examples include Checklist Types, Inspection Types, and Permit Types. Here is how it works:

PTWin32 arrives with a Permit Type called Boundary Line Adjustment as Permit Type number 1. Now if we were to store the words Boundary Line Adjustment with every permit of this type we would add at least 24 characters to the record. On the other hand if we only store the numeral “1” we save all that space and PTWin32 runs faster.

What this means is when you are writing a report that requires one of these Type values you will need to link the number stored with the record to the table that contains the descriptor for the Type

In other words, the Perminfo.db table contains permit information but the Permit Type Key will contain the number “1”, not the words, “Boundary Line Adjustment”.

If your report needs to show the words that describe the Permit Type then you will need to link the Permtype.db into your report.

Linking the Permit Type Keys between Perminfo.db and Permtype.db will allow you to place the Permit Type field on your report.

 

 

Return to Data Model menu Return to Data Model menu