Sample Application Reviewed

Our sample remote host application used multiple forms to show publisher information. A better design would be to use multiple document interface (MDI) children. The traditional approach of opening one database or connection must be changed. The posting of each query's result sets may be done by routines such as:

Sub Query_PublisherUpdate (frm as form, byval MDB$, byval ResultSet$())

or

Sub Query_PublisherUpdate (ctl as frame, byval MDB$, byval ResultSet$)

Each query request produces a separate database that may contain multiple result sets; the process of matching tables and databases to forms and controls is relatively simple if it is designed into the application at the start.