quantum coding
Jul. 27th, 2007 02:36 pmwhen creating queries in microsoft access, there are two different editing modes: SQL view and design view. i usually use SQL view for the same reason that i write HTML (on the rare occasions when i need to) in notepad: fancier microsoft programs tend to write junk code.
here's where the quantum comes in: the act of observing a thing, changes that thing.
whenever you go out of SQL/WYSIWYG mode, access reverts to its own preferred syntax. however sometimes what it prefers is not, technically speaking, correct and functional. so, when you look at your query in design view, access changes your code. sometimes it just makes it ugly, sometimes it alters vital elements.
and what does this boil down to?
YOU CAN BREAK AN ACCESS QUERY JUST BY LOOKING AT IT FUNNY.
here's where the quantum comes in: the act of observing a thing, changes that thing.
whenever you go out of SQL/WYSIWYG mode, access reverts to its own preferred syntax. however sometimes what it prefers is not, technically speaking, correct and functional. so, when you look at your query in design view, access changes your code. sometimes it just makes it ugly, sometimes it alters vital elements.
and what does this boil down to?
YOU CAN BREAK AN ACCESS QUERY JUST BY LOOKING AT IT FUNNY.