Record or DB Document ?
08-Jul-94 11:25:23
Sb: #29875-Record or DB Document ?
Fm: John Nalezny 71000,1025
To: Jean-Louis Leroy 74221,306
I am writing a similar app using the Database Classes. The proto-type, which
was straight ODBC, basicly treated the database like a file system — a query,
which was built from OnFileOpen, would give a list of records and allow the
user to select one to be placed in a new document.
In the actual development we decided to scrap the the majority of the
proto-type in an effort to hold on to the raw query information. Although we
are no were near completion, in this model the query is the document, which can
represent one or several records. The query is serializeable along with the
data source name and hopefully will be OLE server compatible.
Our debate has been whether to include a copy of the resulting data in the file
also. If the data source was not available an OLE container could still
manipulate the data. Microsoft suggested this method, but I cringe when ever
there are two or more copies of the data.
Anyway, the query not only allows the user to modify the records, but also
allows the query to be refined.