CompuServe Messages

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.