MicrosoftAccess continues to frustrate me for internal batch and ad-hoc data-chomping chores. I miss much of ExBase (dBASE derivatives), but realize that its conventions are a bit outdated to be accepted in most organizations. Maybe if us ExBase fans can manage to find a way to modernize the good parts of the language and tool conventions, we can resurrect the wounded beast into a new species that is more palatable to modern conventions/fashions. For one, it probably has to better resemble and better integrate with SQL. SQL is the lingua franca of query languages for good or bad (see SqlFlaws). --top
Suggestions to ponder:
- Replace "FOR" with "WHERE" to fit SQL conventions
- Make "memory" variables start with "$" to avoid confusion with column names.
- Better management and cleanup of "temp" or intermediate/virtual tables, such as auto-cleanup and user/session-specific temporary tables.
- "Mousey" wizards for certain kinds of code generation, and/or perhaps a "format" ControlTable/DataDictionary for column-mapping etc.
- Better or more standardized "area" (handle) management.
- Ability to use multiple RDBMS as its underlying data engine.
- Easy "escape" into direct SQL when needed.
- Review commands that rely on "modey" (global) settings and either remove them, or create non-modal alternatives.
- Toss or make optional hard-wired size limits left over from the early micro-computer era. Example: maximum recognized variable name length. (Older dialects ignored characters beyond a certain name length as a compromise between efficiency and name expressiveness.)
- Table-driven index and auto-join management.
Modernizing Ex Base