Result Sets
In our sample we used an Microsoft Access MDB as a container for the query set. This solution was selected because it appears the to be the best. An MDB permits:
- Multiple result sets: Several SQL queries can be sent at one time with the results saved to different tables.
- Graphics and BLOBs: These may be stored in the database.
- MDB may be fragmented into individual files, which are small enough to be accepted by the mail system; compressed using common compression utilities to speed transmission; and encrypted to provide data security over public mail systems.
For action queries (updates, deletions, insertions), the records may be sent as in an MDB with the query referencing it.