Hi,
Currently I'm writing a database diagnostics application using Delphi 5
and an Access database (which i cannot make changes to). Since I'm not
an experienced Delphi programmer I was hoping you could help me out and
give me some advice.
The database contains observations of some kind. The purpose of the
application is to let the user scan for absurd observations by enabling
a number of filters and setting their parameters. My idea for solving
this problem is to let each of the filters represent a specific query
string which selects all the observations which meets the criteria
specified by the filter. When the user execute a diagnostics the idea
is that all query strings (for selected filters) are joined together:
Filter 1 Query
UNION
Filter 2 Query
..
..
..
UNION
Filter N Query
Then the composite query string is sent to a data module which is
responsible for filling a DataSet with the filtered relations.
Does this seem like a good way to go about this or am I barking up the
wrong tree so to speak? Initially I was thinking about writing a
three-tier application, designing my own DAL but it seems kind of
overkill?
All input would be greatly appreciated!
