I need a
Delphi DPR/EXE application that will:
1) Allow the user to pick an existing
MS Access MDB file
2) Display the available tables within the MDB in a TChecklist
3) Once a table is checked, the app needs to display all the available fields in that selected table in another TCheckList
4) Allow the user to input a 5 digit USA ZIP Code in a TEdit
5) Allow the user to input a distance (in miles) in a TEdit
6) When the user clicks a TButton, the application will:
I) Determine the latitude and longitude values for the ZIP Code entered in #4
II) Iterate through the entire MDB table (see #2) and determine the distance (as the bird flies) from the ZIP Code entered in #4 to each of the ZIP Codes found in each record (#3 defines the ZIP Code field for the selected table).
III) Those records where the distance calculated is less than or equal to the distance specified in #5 should be stored in new temporary table.
IV) Once the entire database has been stepped through, record by record, close the MDB database
7) Using the temporary database that was created, sort the distances in ascending order.
8) Display to the user the number of records that were found
9) Give the user the option to save/export the results to a CSV file.
The values for items 1, 2, 3, 4, 5, 9 should be saved to an INI file and restored back when the application restarts. In other
words, I want the previously used values to be sticky.
I will provide the ZIP Code database containing ZIP Codes and latitude and longitude values.
I will provide the trigonometric algorithms used to calculate distances between latitude and longitudes.
The application can be written in
Delphi 3 through
Delphi 2005.
The application must not use the BDE.
The application should make accessing the MDB file as simple as possible on the user. I would like to avoid having to create ODBC data source. The ideal solution is simply to have the
Delphi app display a File Selection window and allow the user to point to a MDB file and that's it!
