Table creation/Postal addresses: Difference between revisions
Content added Content deleted
m (→version 1: added/changed whitespace and comments, moved a boxed set of REXX program comments to it's own section.) |
m (→{{header|REXX}}: added comment to the REXX section header about the program's logging/tracking capability.) |
||
Line 796: | Line 796: | ||
===version 1=== |
===version 1=== |
||
A REXX program can call SQL or any other database system, but the version shown here is a RYO (roll your own). |
A REXX program can call SQL or any other database system, but the version shown here is a RYO (roll your own). |
||
<br>Practically no error checking (for invalid fields, etc.) has been coded |
<br>Practically no error checking (for invalid fields, etc.) has been coded. |
||
<br>The fields are for the most part, USA specific, but could be expanded |
<br>The fields are for the most part, USA specific, but could be expanded |
||
for other countries. |
for other countries. |
||
<br>In addition to "state", fields such as province, municipality, ward, |
<br>In addition to "state", fields such as province, municipality, ward, |
||
parish, country, etc) could be added without exclusion. |
parish, country, etc) could be added without exclusion. |
||
<br>A logging facility is included which tracks who (by userID) did what update (or change), along with a timestamp. |
|||
<lang>╔════════════════════════════════════════════════════════════════════════════════╗ |
<lang>╔════════════════════════════════════════════════════════════════════════════════╗ |
||
╟───── Format of an entry in the USA address/city/state/zip code structure:──────╣ |
╟───── Format of an entry in the USA address/city/state/zip code structure:──────╣ |