xample_banner.gif Main Index  PREV  NEXT

Valid HTML 4.01!   Valid CSS!

Hidden Forms

For an overview of Hidden forms please go here.


X_Hid1 - get PERSON address

(this is hidden, therefore no form is visible)

This retrieves all the address lines for an address an constructs a single string.


X_Hid2 - fix last address number

(this is hidden, therefore no form is visible)

This reads all PERSON records and ensures that the value in LAST_ADDR_NO matches the number of the last address.


X_Hid3 - fix TREE structure

(this is hidden, therefore no form is visible)

When two adjacent levels in an existing TREE structure are moved apart (because of resequencing) all nodes in the junior level must be updated to clear any reference to a node in the senior level. This turns them into 'orphan' nodes, which allows them to be reattached to a new parent node once the resequencing has been completed.


X_Hid4 - validate PERSON and PERSON ADDRESS dates

(this is hidden, therefore no form is visible)

This validates changes to the start and end dates on PERSON and PERSON ADDRESS records. If a date on an address record is changed this may also change the end date on the previous address or the start date of the next address.


copyright.gif http://www.tonymarston.net