[AccessD] VBA Field Names - Curiosity Question

Arthur,

Why do you find classes more complicated than static functions?  You could
do precisely the same thing with a class, either an individual class for
the value or a globals class to hold all the values, or both.

Charlotte


On Wed, Jul 3, 2013 at 10:17 AM, Arthur Fuller <fuller.artful at gmail.com>wrote:

> I hate globals and prefer static functions (also known as get/set
> functions). They are way superior to global vars. I wrote about this (maybe
> TechRepublic, can't recall, doesn't matter, and will be happy to supply
> some example code upon request. Another approach is to create classes,
> which IMO is too complex, but I'm flexible on this topic.I like static
> functions because they are compact and consist of only few lines of code;
> of course they do not work when passed to a SQL back end, but within Access
> they are wonderful. So my final recommendation is this: if the BE is
> Access, static functions are wonderful; If the BE is something else, say
> MuSQL or MS-SqlServer or Oracle, then static functions should be avoided.
>
>
>