This question is one of those "How would you guys do it". I'm
attempting to replace a MS Access front-end application with RB, though
for the time-being the mdb backend will have to remain. I'm using the
ODBCDatabase class to access the mdb data files.
This application, I suppose is a typical database application that has
numerous tables (people, companies, exhibits, journal, statements etc)
and numerous linking tables. In accessing and displaying the data I'm
using code (not the data controls). In order to display detail
records, this is the general process. Upon window opening, retrieve
all primary key (ie _RowID) fields and store in an array (have to do it
this way as move first, previous & last recordset methods aren't
available). Upon window opening, by default, the first record is
displayed. Navigation buttons (first, prev, next & last) move in the
required direction of the array. From the array the primary key is
retrieved, added to a where clause of an SQL Select statement and that
particular record retrieved and displayed.
Other than the SQL statements (table & field names) being different,
nearly everything else is generic, the process of navigating, retrieving
and displaying records. Positions of various editboxes will vary.
They're are numerous windows to create which all basically do the same
thing, display data for viewing.
What is the most efficient way to approach this, any advice would be
appreciated.
Steven Taylor
Melbourne, Australia.
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
|