Release 10.1A: OpenEdge Development:
Progress Dynamics Basic Development

> ## Site numbers

> The framework assigns a value to this field for every table with a standard database trigger. The value is derived from two (or potentially more) database sequences, whose values are generated by a trigger or by adding your own code to a trigger, are combined to form the high-order and low-order portions of the whole-number portion of the field’s value. The values of two sequences are combined because a single integer might not be sufficient over time to store all possible values for all database records.

> The decimal portion of the value is meant to be a unique site number to identify a particular user organization. The decimal portion is set to the reverse of the site number so that trailing zeros in a site number do not lose their significance. For example, site number `710` yields object ID keys ending in `.017`, and site number `7100` yields key values ending in `.0017`. This is necessary because `.710` and `.7100` have the same decimal value. A site number allocation service exists on the Progress Web site (`http://www.progress.com/dynamics/sitenumber`). The service allows application developers to reserve a range of site numbers for all their customers. Thus, every Progress Dynamics database anywhere in the world can have a unique site number.

> Note: See Chapter 4, "Preparing to Build Application Objects," for more information on the site number application.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095