That's the problem. Any structural changes made by the vendor are out of my control (and knowledge until a problem occurs), so I need a way to dynamically determine that the table has changed. Unfortunately, if they make a fundamental change to any field that I'm using, the report will break anyway. I'm betting, however, that they are adding fields, etc. which are superflous to my reporting engine.
I can add all known fields to my select until they add something later...Can a view be set to "select *" rather than each field individually?
Steve Howie, owner
DaSH Technology
Denver, CO