Gilles Ganault wrote: > On Tue, 04 Mar 2008 09:27:14 -0500, John Elrick > <[EMAIL PROTECTED]> wrote: > >> FYI, we rolled our own adapters for a Delphi project. We had no use for >> the TDataset capabilities and removed the overhead. I would be happy to >> share them if they would help. >> > > I haven't found a good guide/tutorial on Delphi and databases, so I'm > still a bit in the dark as to how all those parts work together, so I > have a couple of questions for you: > - What is the cause of grids showing MEMO instead of the actual > strings defined as TEXT in SQLite? Is it the grid itself, or the > Delphi component to SQLite (Aducom, in this case)? >
The component. We used Aducom for a while and found that TEXT is internally converted to a TMemo field. If you examine the source, you can see the conversions. > - DataSet = either the Table or Query components? If they're removed > from the equation, what are the consequences (performance, features, > connecting the DataSource/DB* components to the SQLite file, etc.)? > Correct, basically any TDataset descendant. Performance improves dramatically in most cases due to the fine tuning on data retrieval. We haven't used TDataSource in quite some time and actually don't miss it. Although for years I was concerned about the cost in programmer time of using disconnected components, I've found the gains from using TDataSource are outweighed by the non-deterministic behavior of the data connections. Our application uses an MVC variant to separate the concerns between the presentation, the model, and the controller. HTH John _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
