Difference between revisions of "Main Page"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
== Design == | == Design == | ||
* [[Naming Conventions|Naming Conventions]] | * [[Naming Conventions|Naming Conventions]] | ||
| − | * Patterns 1:1 | + | * Patterns |
| + | ** 1:1 | ||
| + | ** 1:n | ||
| + | ** m:n | ||
| + | ** Unique number in multi-user environment (SettlementId) | ||
== SQL == | == SQL == | ||
Revision as of 12:20, 28 April 2010
Design
- Naming Conventions
- Patterns
- 1:1
- 1:n
- m:n
- Unique number in multi-user environment (SettlementId)
SQL
Microsoft Access
Technically speaking "Microsoft Access" is a front end for the "Jet Database Engine". For the sake of simplicity and as many people do not know the difference, the database will henceforth be called "Microsoft Access" too.
Coding
Architecture
- Front End
- Back End
Special Objects
- System tables
- Temporary tables (~sq_f*)
- OLEDB-Queries